thiscodeWorks - Organizing the best of code online

List view

#ms.pbi #dax #dax.calculate #dax.filter #dax.all #dax.max #last.week.to.date-lwtd

Sales-LWTD = 

CALCULATE(
    [Sales-WTD],
    FILTER( 
        ALL( 'Calendar'),
        'Calendar'[Week Rank] = MAX( 'Calendar'[Week Rank] )-1 
        )
)

#ms.pbi #dax #dax.calculate #dax.filter #dax.all #dax.max #last.week.to.date-lwtd

DAX | Last Week-to-Date (LWTD) - 1

Sales-LWTD = 

CALCULATE( [Total Sales]), 
	FILTER( ALL( 'Calendar'),
	'Calendar'[Week Rank] = ( MAX ('Calendar'[Week Rank]) -1) && 
	'Calendar'[Weekday] <= < MAX( 'Calendar'[Weekday])
		)
	)

#ms.pbi #dax #dax.calculate #dax.filter #dax.all #dax.max #week.to.date-wtd

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

Sales-WTD = 

CALCULATE( [Total Sales], 
	FILTER( ALL('Calendar'),
		'Calendar'[Week Rank] = MAX( 'Calendar'[Week Rank] ) && 
		'Calendar'[Weekday] <= MAX( 'Date'[Weekday] ) 
		) 
	)

#ms.pbi #dax #dax.calculate #dax.filter #dax.all #dax.max

DAX | Previous Week (PW) Calc - 2

Sales-PW =

CALCULATE ( [Total Sales], 
	FILTER( ALL( 'Calendar' ),
	'Calendar'[Week Rank] = MAX ( 'Calendar'[Week Rank] ) -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
)

DAX | Last Week-to-Date (LWTD) - 2

DAX | Last Week-to-Date (LWTD) - 1

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

DAX | Previous Week (PW) Calc - 2

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

Save snippets that work with our extensions