How to Create a Date Table in Power BI
- George Apostolov
How to Create a Date Table in Power BI: step-by-step guide
Select a data source to start with.
Go to the 'Modeling' tab.
Click 'New Table'.
Paste the following DAX code.
Click the check icon to commit.
Click on the created
DateTable.Go to the 'Modeling' tab and click 'Mark as Date Table'.
Enable and turn on the option 'Mark as a date table'.
Choose the 'Date' column.
Click 'Save' to proceed.
That's it! You have successfully created a date table in Power BI.
Quick answer: To create a date table in Power BI, select a data source, navigate to the Modeling tab, create a new table with DAX code, and commit. Then, mark the table as a date table, select the Date column, and save your changes.
About this Power BI tutorial
Generate a custom date table in Power BI using DAX code. Mark the table as a date table and select the Date column to complete setup. This guide shows how to create a Date Table in Power BI in 11 steps, starting with "Select a data source to start with" and finishing with "That's it! You have successfully created a date table in Power BI". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create a Date Table in Power BI?
11 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Create a Drill Through in Power BI, How to Create a Gauge in Power BI and How to Create a Graph in Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
