Free download

The 12 time-intelligence measures every Power BI model needs

Built for the models where TOTALYTD returns a number that looks right and isn't.

• A date table script with fiscal-year support. One Power Query file. Set the start month, mark the table, done.
• 12 measures, commented. YTD, QTD, MTD, YoY, MoM, rolling 3M and 12M, variance to target, share of total — each one explains the trap it is avoiding.
• The three bugs that produce wrong numbers silently. Fiscal-year TOTALYTD, PREVIOUSMONTH vs DATEADD, and ALL() where you meant ALLSELECTED().
• One zip, four files, readable on a phone. A 4-page PDF guide, the date table script, the measures, and a start-here file — so you are not reading raw markdown on mobile.

Get the pack

One email with the download link. Then one email a week about a Power BI problem worth fixing.

Email address Send me the pack

No spam. Unsubscribe in one click. I don't sell or share your address.

Who made this

Mireia, who writes the Power BI tutorials at powerbitutorials.com. Every measure in this pack is one I use in real models, and every warning in the README is a bug I have shipped at least once.

If a measure misbehaves on your model, tell me — corrections go into the next version and everyone who downloaded gets the update.