The New Zealand date dimension,
done properly.
A ready-to-use calendar table for Power BI, SQL and dbt — with Matariki, Mondayisation, provincial anniversary days and the NZ fiscal year all handled correctly. Built once, so you don't have to.
Most home-grown NZ calendars get the easy 80% right
and quietly get the rest wrong.
Matariki
New Zealand's newest public holiday, correct from its first observance in 2022 through to 2052 (the last gazetted date) — and correctly absent before 2022.
Mondayisation
When Waitangi Day or ANZAC Day falls on a weekend, the observed Monday is flagged via IsObserved, and IsBusinessDay accounts for it.
NZ fiscal year
1 April – 31 March, labelled by the year it ends (FY2026 = 1 Apr 2025 – 31 Mar 2026) — not the US/calendar convention.
17 regional flags
One IsHoliday_<region> column per NZ subdivision — "is this a public holiday in Auckland vs. Wellington" is a single boolean, not a lookup table you build yourself.
Actually maintained
Holiday logic comes from the actively-maintained python-holidays library — not a hand-rolled table that goes stale the moment the law changes.
Free & open
MIT-licensed code, CC BY 4.0 data, public-holiday dates attributed to the New Zealand Government. Use it, fork it, ship it — commercially too.
Six formats, ready now. The Power BI template's next.
All generated from one source of truth, so every format is guaranteed identical. CSV, T-SQL, Snowflake, Databricks, Power Query (M) and dbt are all ready to grab from the repo now. Watch the repo for the Power BI template.
Loaded into your model in about a minute.
Load it
Import the CSV into Power BI, or load it into your warehouse / dbt project as your dim_date table.
Mark & go
In Power BI, mark it as a date table on the Date column and your time-intelligence just works — holidays, fiscal year and all.
Want this wired into reporting that actually answers your questions?
A date table is the easy part. We build the dashboards, data platforms and automation that turn your numbers into decisions — for NZ's builders and makers. That's literally what we do.
Talk to us →