The Australian date dimension,
done properly.
A ready-to-use calendar table for Power BI, SQL and dbt — with all 8 states and territories, state-specific public holidays and the AU fiscal year all handled correctly. Built once, so you don't have to.
Most home-grown AU calendars stop at "national holidays"
and quietly ignore the states.
8 states & territories
One IsHoliday_<STATE> column for each of ACT, NSW, NT, QLD, SA, TAS, VIC and WA — "is this a public holiday in Victoria vs. Queensland" is a single boolean, not a lookup table you build yourself.
State-specific holidays
Melbourne Cup (VIC), the Ekka (QLD), Adelaide Cup (SA) and each state's own Labour Day — scoped to the jurisdiction that actually observes them, not sprayed across the whole country.
AU fiscal year
1 July – 30 June, labelled by the year it ends (FY2026 = 1 Jul 2025 – 30 Jun 2026) — the convention Australian business and government reporting actually uses.
National vs. state calendars
Australia's national public holiday list doesn't shift a weekend holiday to the following Monday — the real days off live in the per-state IsHoliday_<STATE> flags, which follow each jurisdiction's own rules.
Actually maintained
Holiday logic comes from the actively-maintained python-holidays library — not a hand-rolled table that goes stale the moment a state changes its calendar.
Free & open
MIT-licensed code, CC BY 4.0 data. 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. That's literally what we do.
Talk to us →