Select Page

VIDEO: Creating the Calendar Table in Power BI

by | Jun 5, 2020 | Video

When building a report in Power BI, it is recommended to create a calendar table. The calendar helps to better organize data and perform a more in-depth analysis using time-intelligence functions.

In this tutorial, we will learn how to create a calendar table, so a further and more in-depth analysis could be performed.

The easiest way to quickly create a calendar is to use the function CalendarAuto. It will automatically take the first and last dates from your data and produce a calendar. However, using the CalendarAuto function is a bad practice, as in some cases it may lead to mistakes in your data model.

That is why it is better to use the Calendar function: TableName = Calendar ([Start Date], [End Date]).

If you don’t know the start and end dates in your model, one solution is to use functions MIN and MAX inside the Calendar function.

Share This