How do I add a calendar table in Power BI?

In Power BI Desktop go to Modeling, click New table, paste the DAX, and press Enter. Then use Mark as date table and pick the Date column.

How do I get Hijri dates in Power BI?

Power BI has no built-in Hijri functions. This generator embeds the Umm al-Qura month start dates in the DAX, then calculates Hijri year, month, day, Ramadan and Eid for every date.

Are the Ramadan dates exact?

By default they follow the official Saudi Umm al-Qura calendar, and a moon sighting can differ by one day. The Announced Ramadan and Eid dates option uses the dates the UAE announced since 2018; future dates are estimates until they are announced.

Free tool · No sign-up

DAX Calendar Table Generator

A complete 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

Table name

Start date

End date

Week starts on

Weekend

Fiscal year starts

Month and day names

Columns to include Hijri dates, Ramadan and EidUmm al-Qura calendar: Hijri year, month, day, Ramadan day, Eid al-Fitr and Eid al-Adha flags. Announced Ramadan and Eid dates (UAE)Moves Ramadan, Shawwal and Dhu al-Hijjah to the dates the UAE announced since 2018. Dates not announced yet stay on Umm al-Qura and are flagged in Is Estimated Date. Fiscal year, quarter and monthLabels like FY2026 and FQ1, based on your fiscal start month. Relative offsetsDay, month and year offsets from today, for "last 3 months" slicers that never need updating.

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 changes everything in your numbers

Comparing this Ramadan to last Ramadan, not March to March, is where the real insight is. DataArcus builds Power BI reports that understand the Gulf calendar.

Book a Free Call Next: build YoY and YTD measures

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 Hijri functions. 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 works offline and refreshes instantly.

Are the Ramadan and Eid dates exact?

By default they follow the official Saudi Umm al-Qura calendar, and a moon sighting can differ by one day. Turn on Announced Ramadan and Eid dates to use the dates the UAE announced since 2018 (only Ramadan 2018 differed). Future dates are estimates until they are announced.

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 always show the last three months. It updates by itself every day, so nobody has to change a slicer again.