Make Calendars Using DAX – Curbal

Often you will need to create some custom calendars within your PowerBI reports. Ruth Pozuelo from Curbal does a great video tutorial on using Calendar() and CalendarAuto(). I have used the Calendar() DAX function many times and find it very helpful.

Different Approaches to Date Tables

The following videos are built directly within DAX. This approach is one of many different methods that can be used to generate a list of dates. In a previous tutorial I talked about how to build a date table within the Query Editor (build date table in the Query Editor).

One method that Ruth talks about is the ability to use the CalendarAuto(). I have not used this expression in any previous reports, but seeing how simple it is to implement this will definitely have to be added to the toolbox.

DAX Calendar Functions

Microsoft Docs on Calendar()

See Calendar DAX example below:

= CALENDAR (DATE (2005, 1, 1), DATE (2015, 12, 31))

Microsoft Docs on CalendarAuto()

See CalendarAuto DAX Example below:

= CALENDARAUTO()

Video Tutorials from Curbal

Here are the highlights from Ruth’s video:

Using Calendar

Using CalendarAuto

Learn More

Curbal has been generating a lot of great content. To learn about more information you can visit the website found here, or visit the YouTube Channel.

For more great videos about Power BI check out our videos page.