Recent | Popular
#ms.pbi #dax #dax.ranks #dax.all #ranking
Sales Rep Rank = RANKX( ALL( Sales[Sales Rep]), [Total Sales], Dense ) //Dense = not skip
#ms.pbi #dax #dax.topn #ranking #dax.format #dax.concatenatex
Best Selling Day/Date = CONCATENATEX( TOPN( 1, 'Calendar', [Total Sales] ), FORMAT( 'Calendar'[Date], "dd-mmm" ) )
#ms.pbi #dax #dax.topn #ranking #dax.values
Top Selling Product = TOPN( 1, VALUES( Sales[ProductID] ), [Total Sales] )
#ms.pbi #dax #dax.topn #ranking
Best Selling Day/Date = TOPN( 1, 'Calendar', [Total Sales] )
#ms.pbi #dax #calendar.table #dax.rankx #dax.asc #dax.dense #ranking #week.rank
Week Rank = RANKX( ALL( 'Calendar' ), 'Calendar'[Week StartDate], , ASC, Dense)
Tue Dec 26 2023 07:58:24 GMT+0000 (Coordinated Universal Time)
Mon Dec 25 2023 14:05:21 GMT+0000 (Coordinated Universal Time)
Mon Dec 25 2023 13:57:48 GMT+0000 (Coordinated Universal Time)
Mon Dec 25 2023 13:55:40 GMT+0000 (Coordinated Universal Time)
Mon Dec 18 2023 02:24:45 GMT+0000 (Coordinated Universal Time)