After all, Power BI allows you to include fields from date hierarchies which are created automatically for you:
When I was first learning Power BI (actually, it was PowerPivot in those days, those many moons ago), I didn’t initially see the point of calendars. You’ll be using some of these tables in what follows, and some in the next article in the series. In addition, you should have the following four tables which aren’t linked: These tables will give you the following data model: Tick all of the worksheets when you’re loading data into a new Power BI report: To work through the examples in this article, you’ll need to download the worksheets from this workbook.
#PRIMARY DATE COLUMN POWER BI HOW TO#
The article will also answer questions such as: what happens if you have two or more dates in the same table that you want to reference? Or if you have another table which holds information at a different level of granularity? Or if you want to report sales by bank holidays? Read on for how to create a robust data model for handling time-based data! Loading the Sample Data for this Article