Weekday =

WEEKDAY( [Date], 2 )
Week End date =

'Calendar'[Date] + 7-1 * WEEKDAY( 'Calendar'[Date], 2 )
Week Start date =

'Calendar'[Date] + -1 * WEEKDAY( 'Calendar'[Date], 2 ) + 1
Sales-WTD =

VAR CD =
LASTDATE( 'Calendar'[Date] )

VAR CY =
MAX( 'Calendar'[Year] )

VAR WeekDayNo =
WEEKDAY( LASTDATE( 'Calendar'[Date] ), 3 )

RETURN
CALCULATE(
[Total Sales],
DATESBETWEEN(
'Calendar'[Date],
CD,
-1 * WeekDayNo, DAY ),
CD),
'Calendar'[Year] = CY
)
DayofWeekNo =
WEEKDAY ( [Date], 2 )
Week StartDate =

'Calendar'[Date] + -1*WEEKDAY( 'Calendar'[Date], 2 ) + 1
Week EndDate =

'Calendar'[Date] + 7-1*WEEKDAY( 'Calendar'[Date], 2 )
star

Sat Dec 30 2023 07:12:45 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.weekday
star

Sat Dec 30 2023 07:07:22 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.weekday
star

Sat Dec 30 2023 07:06:37 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.weekday
star

Mon Dec 18 2023 02:33:17 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #dax.weekday #calendar.table
star

Mon Dec 18 2023 02:23:35 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #calendar.table #dax.weekday
star

Mon Dec 18 2023 02:22:15 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #calendar.table #dax.weekday