How do I add many measures at once in Power BI?

Open DAX query view in Power BI Desktop, paste a DEFINE block with several MEASURE lines, and click Update model with changes. All measures are added in one step.

Free tool · No sign-up

DAX Measure Builder

Q: How do I calculate year over year growth in DAX?

Create a prior-year measure with CALCULATE and SAMEPERIODLASTYEAR, then divide the difference by it: DIVIDE([Sales] - [Sales PY], [Sales PY]). DIVIDE returns blank instead of an error when last year is empty.

Q: Why do my time intelligence measures return blank or wrong values?

Time intelligence needs a proper date table: one row per day with no gaps, marked as a date table, and related to your fact table. Use the date column from that table in visuals and in the measures.

One base measure in, a full set of time intelligence out: YTD, prior year, YoY %, rolling months, running totals, even Ramadan vs last Ramadan. Add them all to Power BI in one click.

1. Your base measure

Calculation

Measure name

Fact table

Column

Existing measure name

Put new measures in table

2. Your date table

Date table

Date column

Fiscal year ends

Rolling months / avg days

No date table yet? Generate one here first.

3. Pick your measures

In Power BI Desktop open DAX query view (left toolbar), paste, and click Update model with changes. Every measure is added in one go.

In Power BI Desktop open TMDL view (left toolbar), paste, and click Apply. Every measure is added with its number format, a display folder and a description. Needs Desktop from 2025 on.

Ramadan and Eid measures use the Hijri Year, Hijri Month Number, Hijri Day, Is Ramadan and Ramadan Day columns from the DataArcus calendar.

Measures are easy. The right numbers are not.

When totals don’t match, relationships double count, or YoY looks wrong, the problem is the model. DataArcus builds and fixes Power BI data models.

Book a Free Call Free DAX Calendar Generator

Guide: why YoY breaks in Ramadan, and the measure that fixes it →

Questions

How do I calculate year over year growth in DAX?

Make a prior-year measure with SAMEPERIODLASTYEAR, then use DIVIDE(current - prior year, prior year). DIVIDE returns blank instead of an error when last year has no data. Tick "YoY %" above and the builder writes both for you.

How do I add all the measures at once?

Use DAX query view in Power BI Desktop. Paste the whole script and click Update model with changes. Then set the % measures to Percentage format in the Measure tools ribbon.

My YTD or PY measure is blank. Why?

Time intelligence needs a real date table: one row per day, no gaps, marked as a date table, and related to your fact table. Use that table’s Date column on your visuals, not the date column from the fact table.

What is the difference between Rolling 3M and 30D Avg?

Rolling 3M adds up the last three months, which is great for smoothing seasonal sales. 30D Avg is the average per day over the last 30 days, which is better for trend lines on daily data.

How does Ramadan vs last Ramadan work?

Ramadan moves about 11 days earlier every year, so comparing March with March is misleading. The measure looks up the same Ramadan days in the previous Hijri year. Put Ramadan Day on the axis and you compare day 5 with day 5.