Modifying weeknumber based on weekstart on Friday

[Anonymous]

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!

[amitchandak · Accepted solution]

@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/1187482

I have given for all 7 days