A ready-made date table for Power BI and Excel
Every good Power BI or Excel model needs a proper date (calendar) table. This tool builds one in seconds with the columns UK reports actually need:
- Calendar columns: Year, quarter, month name and number, Year-Month, day name, ISO week and week start.
- UK bank holidays: England & Wales, Scotland or Northern Ireland, including substitute days and one-off holidays, following the GOV.UK rules.
- Working days: An Is Working Day flag and a working-day-of-month counter, perfect for daily targets and SLAs.
- Financial year: Starting 1 April, 6 April, 1 January or any month, with fiscal month and fiscal quarter.
- UK tax year: Tax year (for example 2026/27), tax month (6th to 5th) and tax week, as used in payroll.
Use the table as an Excel file, or copy the ready-made DAX Or Power Query (M) Code straight into Power BI so it refreshes automatically.