Forum Discussion

Frequent Visitor

5 years ago

Solved

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

Need Help

V-lianl-msft
5 years ago
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.

amitchandak

Super User

5 years ago

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

EricHyon

Frequent Visitor

5 years ago

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
Community Support
5 years ago
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.

Forum Discussion

ISO Format with Weeks Starting Sunday

Related content

User Group Leader Get Started Guide

Set calendar to start on a Sunday

Calendar slicer starting week Mondays instead of Sundays

Daily AR, Trying to Calculate This Sunday vs. Last Sunday

Lakehouse Cold Start