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

PHOTO EMBED

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

Saved by @nikahafiz #ms.pbi #dax #dax.calculate #dax.filter #dax.all #dax.max #last.week.to.date-lwtd

Sales-LWTD = 

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