Dim Calendar: M or DAX

[ovetteabejuela]

Which is better to implement Calendar Dimension Table in, M or DAX?

[dexterz]

i like dax,dax is sample.

Date =ADDCOLUMNS (

    CALENDAR ( "2010-01-01", "2014-12-31" ),

    "Year", FORMAT ( [Date], "YYYY" ),

    "Quarter", "Q" & FORMAT ( [Date], "Q" ),

    "MonthNum", FORMAT ( [Date], "MM" ),

    "Month", FORMAT ( [Date], "MMM" ),

    "Weekday", FORMAT ( [Date], "ddd" ),

    "WeekdayNum", WEEKDAY ( [Date], 2 ),

    "Day", FORMAT ( [Date], "dd" ),

    "Cal Month", FORMAT ( [Date], "YYYY-MM" ),

    "Cal Quarter", FORMAT ( [Date], "YYYY" ) & "-Q"

        & FORMAT ( [Date], "Q" ))

[ovetteabejuela]

well, I like both and I agree  wit @dexterz that DAX is simpler but I also like to implement this Dim via Power Query so it's processed at design time not on live data..

Another but... I also like to implement in M the bahaviour of Calendar() function wherein you can specify the start and end date.

I'm torn but I think for now I will go with DAX just because it's easy for me to implement... but long term for me is M.

I just maybe need some help implementing it in M, trying to read through the link shared by @MFelix

[MFelix · Accepted solution]

HI @ovetteabejuela,

In my opinion it M follow this link and you can add a calendar table to use. Very handy when you are making Date based reports.

https://community.powerbi.com/t5/Community-Blog/The-quot-only-quot-Power-BI-calendar-you-will-ever-n...

Regards,

MFelix