News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Getting nth Week in a ...

Power Apps - Building Power Apps

Answered

Getting nth Week in a month

Like (0) Share

Report

Report

Posted on 8 Dec 2022 10:20:40 by dalecombrink

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

Categories:

General Questions

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

LaurensM 12,510 Super User 2025 Season 1 on 08 Dec 2022 at 11:10:11

Like (0)

Report
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!