Forum Discussion
Week Offset - Where Week Starts on a Saturday
Hey Guys,
I was wondering if anyone could help me. I need to work out the Week Offset. However our week starts on a Saturday rather than Sunday or a Monday.
This is the formula we previously used when our week started on a Monday.
Cutten101 , these will help you to get the week start for Saturday or any day
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
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e6f593958
3 Replies
- amitchandak
Super User
Cutten101 , these will help you to get the week start for Saturday or any day
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
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e6f593958Thank you, the examples in these forums helped me create the offset
Hi Cutten101 ,
Please try below dax formula
Week Offset = VAR StartOfWeek = 'Date'[Date] - WEEKDAY ( 'Date'[Date], 16 ) + 1 VAR StartOfCurrentWeek = TODAY () - WEEKDAY ( TODAY (), 16 ) + 1 RETURN ( StartOfWeek - StartOfCurrentWeek ) / 7For more details, you can read related document: WEEKDAY – DAX Guide
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
