Forum Discussion
Solved
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 ...
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
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 ) / 7
For 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.