Recent | Popular
#ms.pbi #dax #dax.calculate #current.week #dax.filter #dax.all #week.rank
Sales-CW = CALCULATE( [Total Sales], FILTER( ALL('Calendar'), 'Calendar'[Week Rank] = MAX( 'Calendar'[Week Rank]) ) )
#ms.pbi #dax #calendar.table #dax.rankx #dax.asc #dax.dense #ranking #week.rank
Week Rank = RANKX( ALL( 'Calendar' ), 'Calendar'[Week StartDate], , ASC, Dense)
Sat Dec 30 2023 04:54:52 GMT+0000 (Coordinated Universal Time)
Mon Dec 18 2023 02:24:45 GMT+0000 (Coordinated Universal Time)