thiscodeWorks - Organizing the best of code online

List view

Weekday = 

WEEKDAY( [Date], 2 )

#ms.pbi #dax #dax.weekday

DAX | Week End Date (Week Begins on Monday)

Week End date = 

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

#ms.pbi #dax #dax.weekday

DAX | Week Start Date - 2 (Week Begins on Monday)

Week Start date = 

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

#ms.pbi #dax #dax.var #dax.return #week.to.date-wtd #dax.lastdate #dax.max #dax.weekday #dax.calculate #dax.datesbetween #dax.dateadd

DAX | Week-to-Date (WTD) - 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],
        DATEADD(
            CD, 
            -1 * WeekDayNo, DAY ), 
            CD),
    'Calendar'[Year] = CY
)

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

DAX | Day of Week No

DayofWeekNo = 
WEEKDAY ( [Date], 2 )

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

DAX | Week Start Date - 1 (Week Begins on Monday)

Week StartDate = 

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

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

DAX | Week End Date

Week EndDate = 

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

DAX | Week Day (Week Begins on Monday)

DAX | Week End Date (Week Begins on Monday)

DAX | Week Start Date - 2 (Week Begins on Monday)

DAX | Week-to-Date (WTD) - 1

DAX | Day of Week No

DAX | Week Start Date - 1 (Week Begins on Monday)

DAX | Week End Date

Save snippets that work with our extensions