DAX for Power BI Part 7.1 - Creating Basic Calendar Tables in DAX

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

Learn how to replace the auto date-time calendars in Power BI with a custom calendar using the CalendarAuto and Calendar DAX functions.

Chapters
00:00 Topic List
00:54 Disabling the Auto Date Time Feature
04:04 Custom Calendar Rules
05:31 The CalendarAuto and Calendar Functions
08:33 Using Variables for the Start and End Dates
10:56 Adding New Columns to the Table
13:19 Years, Quarters, Months and Days
15:51 Month and Weekday Names
17:02 Concatenating Labels
17:44 Combining Intervals in a Single Label
19:29 Marking a Table as a Date Table
20:32 Disabling Aggregation for Number Fields
21:23 Assigning Sort By Columns
22:34 Hiding Columns from the Report View
23:27 Displaying the Calendar in a Visual
24:32 Creating a Relationship to the Calendar Table
25:41 Creating a Hierarchy
27:24 Time Intelligence with Custom Calendars

[pnruk]

This man changed my life many many years ago with his SSRS tutorials :) I still watch them every now and again to feel a little bit of nostalgia! Good to hear your voice again on this topic.

[seantame]

Great tutorial - even I can follow it!! One question from me. You called this table ReleaseCalendar. (forgetting the lower and upper bounds for a moment) could this table not also be linked to any other date in the model? Assume you have a Sales table with Order Date, Ship Date, Invoice Date etc, can you not link this one table to all of them or do you need one per date column? (sorry if you covered that but I did not notice it)

[PowerBILearner-cd]

Hi. Why do we use the column name only instead of table name and column name in the functions calls that create the table columns? e.g. DAY([Date]), why isn't it DAY('ReleaseCalendar'[Date])?

[samirmishra]

what is the use to mark as Date Table, if we not mark it what could be the issue?