Free Power BI Date Table Generator
Pick a year range and your fiscal year start month, get back a ready-to-paste DAX date table — Year, Quarter, Month Name, Week Number, Fiscal Year, all included — plus the exact "Mark as date table" steps. Instant, no signup.
Paste this as a new table (Modeling > New table)
Setup steps
Why a dedicated date table, not Power BI's auto date/time
Power BI can auto-generate a hidden date hierarchy per date column, but it builds one PER column (wasteful with several date fields), can't be shared across fact tables, and doesn't support custom fiscal years. A single, explicit date table related to every fact table's date column is the standard practice — one calendar, reused everywhere, with real time-intelligence functions (TOTALYTD, SAMEPERIODLASTYEAR) working correctly against it.
The real "Mark as date table" requirements
Confirmed against Microsoft's own current guidance: the date column must be Date/time type, every value must be unique (no duplicates), no blanks, and the table must cover every single day in the range with no gaps — a table missing even one day will fail validation. The generator above builds the full continuous range via CALENDAR(), so none of that is left to chance.
Fiscal year, only when you actually need it
Leave the fiscal month on January and the output skips the Fiscal Year column entirely — it would just duplicate Year. Pick any other month and a real Fiscal Year column is added, computed so the fiscal year rolls over on that exact month (e.g. a July fiscal start means January-June 2026 is fiscal year 2026, but July 2026 onward is fiscal year 2027).
Questions
Is this free?
Yes, completely free, no account or signup needed.
Do I still need to mark it as a date table manually?
Yes — pasting the DAX creates the table, but Power BI only treats it as a true date table (unlocking classic time-intelligence functions) once you right-click it, choose "Mark as date table", and select the Date column. The setup steps above cover this exact click path.
What's the difference between this and the DAX time intelligence generator?
This builds the calendar table itself (Year/Quarter/Month/Week columns, once). The time intelligence generator writes the actual measures (YTD, prior year, rolling average, etc.) that run against a date table like this one.
Why does the generated table use WEEKNUM instead of ISOWEEKNUM?
WEEKNUM with return type 2 (week starts Monday) is the more commonly expected default. If you specifically need ISO 8601 week numbering, swap that one line for ISOWEEKNUM([Date]) in the pasted DAX — both are real, native DAX functions.
Have your real data ready? Build the dashboard.
Upload your file, describe what you want, and get back a real, editable .pbip project today — free, no Fabric or Copilot license needed.
More free tools: DAX time intelligence generator · incremental refresh calculator · DAX cheat sheet · see all →