Make Calendars Using DAX – Curbal

August 30, 2016 By Mike Carlo

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.

Mar 25, 2026

Git Best Practices Diff Noise & Naming - Ep. 513

Mike and Tommy break down the Git habits that make pull requests easier to review, cleaner to merge, and less painful to maintain over time. If your team fights diff noise, inconsistent naming, and mystery changes buried in commits, this episode gives you a practical framework for cleaning that up.

Mar 20, 2026

Publish to Web vs. Embedded - Ep. 512

Mike and Tommy break down the real difference between Publish to Web and Power BI Embedded, and why mixing them up creates security and governance headaches fast. If you need to share reports outside your organization, this episode gives you the practical framework for choosing the right option without accidentally turning convenience into a data leak.

Mar 18, 2026

Scaling a Power BI Side Hustle - Ep. 511

Mike and Tommy break down what it actually takes to grow a Power BI side hustle from occasional freelance work into a repeatable consulting engine. If you're balancing client delivery, productized offers, and the reality of limited time, this episode gives you a sharper playbook for scaling without creating chaos.