Recent | Popular
#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] )
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)