Free tool · No sign-up

DAX Calendar Table Generator

A Power BI date table in one paste: fiscal years, GCC weekends, and Hijri dates with Ramadan and Eid flags that no built-in function gives you.

Quick setup
Is Weekend and Is Working Day follow this weekend only: they don't know public holidays, half days (the UAE government works a half day on Friday) or an employer's own rest days.
Columns to include
Preview
Ramadan in your date range
Your DAX

            

In Power BI Desktop: Modeling → New table, paste, press Enter. Then Mark as date table and choose Date. Sort Month Name by Month Number.

Ramadan moves every year, and your numbers with it

Compare this Ramadan with last Ramadan, not March with March. DataArcus builds Power BI reports that understand the Gulf calendar: see DataArcus for Power BI.

Read the guide: compare this Ramadan with last Ramadan →

Questions

How do I add this table in Power BI?

In Power BI Desktop go to Modeling → New table, paste the DAX and press Enter. Then right-click the table, choose Mark as date table, and pick the Date column. Relate Date to the date column of your fact table.

How does it get Hijri dates without Power Query?

Power BI has no built-in function that returns a Hijri month or flags Ramadan. (Measured in Power BI Desktop 2.158, October 2026: DAX FORMAT with "ar-SA" or "ar-AE" still returns the Gregorian date.) The generator calculates every Hijri month start in your range and embeds them in a small DATATABLE inside the DAX. Each date then looks up its Hijri month, so the table needs no data source and works offline.

Are the Ramadan and Eid dates exact?

By default they follow Saudi Arabia's Umm al-Qura calendar; a moon sighting can differ from it, usually by a day. Turn on Announced Ramadan and Eid dates to use the dates the UAE announced since 2018 (only Ramadan 2018 differed from Umm al-Qura). They are the UAE's dates: Oman announced 11 of them a day later from 2019 to 2026. Future dates are estimates until they are announced and added here.

How do I compare this Ramadan with last Ramadan?

Put Ramadan Day on the axis and Hijri Year in the legend. Every Ramadan lines up day by day, even though the Gregorian dates move about 11 days earlier each year.

Why relative offsets?

Filter on Month Offset between -2 and 0 to show the last three months. The offsets are worked out when the table is calculated, so they move on with each refresh of the model (or when the file is opened again), not at midnight: refresh it every day and the filter keeps showing the last three months.