Week Offset - Where Week Starts on a Saturday

[Cutten101]

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.

Week Offset =

Var StartOfWeek = 'Date'[Date] - WEEKDAY( 'Date'[Date], 2)+1

Var StartOfCurrentWeek = TODAY() - WEEKDAY(TODAY(), 2)+1

Return (StartOfWeek - StartOfCurrentWeek)/7

But now we need the week to start on a saturday, and the WeekDay Function does not cater for this. Any ideas would be greatful.

[v-binbinyu-msft]

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.

[amitchandak · Accepted solution]

@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-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...

[Cutten101]

Thank you, the examples in these forums helped me create the offset