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 #calendar.table #dax.format #dax.calendar #format-ddd
DayName = FORMAT ( 'Calendar'[Date], "ddd" )
#ms.pbi #dax #calendar.table #dax.addcolumns #dax.var #dax.return #dax.format #dax.month
Calendar = VAR CalTable = CALENDARAUTO () VAR MyCal = ADDCOLUMNS ( CalTable, "Index", MONTH ( [Date] ), "Month", FORMAT ( [Date], "mmm" ), "Qtr", FORMAT ( [Date], "\QQ" ), "Year", FORMAT ( [Date], "yyyy" ) ) RETURN MyCal
Mon Dec 25 2023 14:05:21 GMT+0000 (Coordinated Universal Time)
Mon Dec 18 2023 02:30:50 GMT+0000 (Coordinated Universal Time)
Sat Dec 09 2023 15:24:37 GMT+0000 (Coordinated Universal Time)