How to Create a Date Table in Power BI

Quick summary

A Date Table in Power BI is a dedicated calendar table created with a DAX formula and marked as an official date table, enabling accurate time-intelligence calculations across all your reports. This tutorial walks you through every step — from opening the Modeling tab to marking the table as a date table — so your time-based measures always return correct results.

Steps

1. Select a data source to start with.
2. Go to the Modeling tab.
3. Click New Table to create a blank calculated table.
4. Paste the DAX code into the formula bar to generate your date table.
5. Click the check icon to commit the DAX expression.
6. Click on the newly created DateTable in the Fields pane.
7. Go back to the Modeling tab and click Mark as Date Table.
8. Enable the option Mark as a date table in the settings panel.
9. Choose the Date column as the unique date identifier.
10. Click Save to confirm and apply the date table settings.
11. Your Date Table is now successfully created and marked in Power BI.