Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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êsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |