Power BI Date Table Generator

Generate a reusable DAX calendar table for Power BI with year, quarter, month and sorting columns.

A calendar your model can build on.Browser processing

Start year

End year

Table name

DAX

How to use it

From input to insight.

Paste into New table in Power BI Desktop. Mark it as a date table using [Date], create the relationship to your fact date, sort Month by Month Number, and sort Weekday by Weekday Number.

What to know

Creates a calendar covering complete years, including leap days, with numeric sorting columns. This template uses calendar years; it does not add fiscal calendars or holiday rules.

← Explore all tools