How to Create a Date Table in Power BI



Guide

  1. Select a data source to start with.

  2. Go to the 'Modeling' tab.

  3. Click 'New Table'.

  4. Paste the following DAX code.

  5. Click the check icon to commit.

  6. Click on the created DateTable.

  7. Go to the 'Modeling' tab and click 'Mark as Date Table'.

  8. Enable and turn on the option 'Mark as a date table'.

  9. Choose the 'Date' column.

  10. Click 'Save' to proceed.

  11. That's it! You have successfully created a date table in Power BI.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline