Recent | Popular
#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
Sat Dec 09 2023 15:24:37 GMT+0000 (Coordinated Universal Time)