web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

Power Apps

Answered

Getting nth Week in a month

(0) Share

Report

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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!

Was this reply helpful? Yes No

Join the conversation