zvity

Date table generator

Pick a period and settings, then copy the code into Power BI. Names, fiscal year and holidays are taken care of.

Period
Code format
Ukrainian public holidays

Under martial law, article 73 of the Labour Code doesn’t apply, so public holidays are working days. That’s why holidays are only marked by default. The list may change: check that it’s current.

DAX

First rows

The fiscal year is named after the year it ends in.

How to add it to Power BI

    Period comparison measures: Year to date, prior year, % change, rolling 12 months: ready DAX measures in one script.

    Files are processed only in your browser and are never sent anywhere.