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
- Select a data source to start with.
- Go to the Modeling tab.
- Click New Table to create a blank calculated table.
- Paste the DAX code into the formula bar to generate your date table.
- Click the check icon to commit the DAX expression.
- Click on the newly created DateTable in the Fields pane.
- Go back to the Modeling tab and click Mark as Date Table.
- Enable the option Mark as a date table in the settings panel.
- Choose the Date column as the unique date identifier.
- Click Save to confirm and apply the date table settings.
- Your Date Table is now successfully created and marked in Power BI.
