Forum Discussion
ISO Format with Weeks Starting Sunday
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.
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.
3 Replies
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-Power-BI-Turning/ba-p/1187482Thanks 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.
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.
