Adding Calendar Table in Power Pivot

The calendar table is an essential aspect of robust data modeling. Previous articles explain how to create a calendar or a date table using DAX measures and Power Query.

This article covers how simple it is to create a calendar table in Power Pivot.

Adding a Calendar Table in Power Pivot

In the Power Pivot Data Model > Design > Date Table > New

It adds a table in the data model (table name: Calendar):

The first column in the table Date is equivalent to the CALENDARAUTO function. The values of this column change according to the date columns in the data model. It considers all the date columns present in the model and creates the range of dates in the column.

The rest of the columns in the table are calculated columns. We can modify them as per our requirement.