Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ovetteabejuela
Impactful Individual
Impactful Individual

Dim Calendar: M or DAX

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

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
dexterz
Helper II
Helper II

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" ))

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
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.