Power Pivot Principles: Basic Use of Calendar Table
4 September 2018
Welcome back to our Power Pivot blog. Today, we discuss the steps we should take when creating a Calendar Table.
In our previous blog (link to previous blog) we discussed on the steps we have to take to create a Calendar table. In this blog, we will discuss how to create future PivotTables once we have linked our Calendar table.
When creating new PivotTables from our Power Pivot Data we should always use date sources from the Calendar Table. In fact, if you always call your date field in the Calendar table ‘Date’, then any time series function in DAX requiring a date should cite Calendar[Date] – simple!
Create a PivotTable with fields from any table in the data model, then use the date fields from the Calendar Table.
It is important to use the Calendar Table because all of the time intelligence for example the DATESYTD function, requires the contiguous dates to function properly.
We will cover the DATESYTD function next week.
Stay tuned for our next post on Power Pivot in the Blog section. In the meantime, please remember we have training in Power Pivot which you can find out more about here. If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.