Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 3ZnLpEZrFReFYK7n4iUrGA
Power Apps - Building Power Apps
Answered

Getting nth Week in a month

Like (0) ShareShare
ReportReport
Posted on 8 Dec 2022 10:20:40 by 17

I am looking to create a collection similar to a question posed on the PowerBi forum but using Powerapps.

I am looking to see if Today() falls under which week in a month as we need to lock buttons depending on which week of the month it is

dalecombrink_0-1670494728037.png

 

Categories:
  • Verified answer
    LaurensM Profile Picture
    12,510 Super User 2025 Season 1 on 08 Dec 2022 at 11:10:11
    Re: Getting nth Week in a month

    @dalecombrink I didn't find a native function that could solve this.

    However, I used the WeekNum() function that retrieves the current week of the year as a number.

    With the function below we check the current week value and decrease it with the value of the week before the start of this month:

    WeekNum(
     Today(),
     StartOfWeek.Monday
    ) - (WeekNum(
     Date(
     Year(Today()),
     Month(Today()),
     01
     ),
     StartOfWeek.Monday
    ) - 1)

     

    I hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 205 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 108

#3
stampcoin Profile Picture

stampcoin 80

Overall leaderboard
Loading started
Loading complete