ISO Format with Weeks Starting Sunday

[EricHyon]

I am creating reports where I must use ISO format where the first week of the year is the first Thursday of the year, but I need to have the weeks starting Sunday. 

I have found temporary ways to solve this problem but looking for a permanent solution where I do not have to constantly customize the formula every year

In the image below, the dates for 1/1/2021 and 1/2/2021 should be considered Week 53.

For Dates 1/3/2021 and on, the weeks should be subtracted by 1. 

[amitchandak]

@EricHyon , Iso week can find as

ISO Week = weeknum([Date],21)

See if this can help

if needed also check

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-Powe...

[EricHyon]

Thanks for the reply. Unfortunately, this solution has the 1st week starting on Monday 1/4/2021. I was looking for a solution where the 1st week starts on Sunday 1/3/2021.

[V-lianl-msft · Accepted solution]

Hi @EricHyon ,

Please refer to the same thread:

https://community.powerbi.com/t5/Desktop/Leap-year-week-number/m-p/1588002 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.