Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Which is better to implement Calendar Dimension Table in, M or DAX?
Solved! Go to 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.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsi 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" ))
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
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.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |