Forum Discussion
Modifying weeknumber based on weekstart on Friday
Hi, im struggeling to find out a formula that can modify the weeknumber so the week starts at friday.
I have tried Weeknumber = WEEKNUM ([Date.Date],1) but it seems that you only can choos between 1 and 2 in the end of the formula.
What I want is the following (12.31.2021 was a friday):
Week 1 is 12.31.2021 - 01.06.2022
Week 2 is 01.07.2022-01.13.2022
And so on...
Here is an example of how I want it to look in a table (02.18.2022 was a friday):
Appriciate any help!
Anonymous , refer my blog for the same
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482I have given for all 7 days
1 Reply
- amitchandak
Super User
Anonymous , refer my blog for the same
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482I have given for all 7 days