topic Re: explain YOY (Year-over-Year) Growth % in the simplest way in DAX Commands and Tips

explain YOY (Year-over-Year) Growth % in the simplest way

Sania-F — Wed, 24 Sep 2025 12:50:31 GMT

YOY growth tells you how much revenue has increased (or decreased) compared to the same period last year.

YOY%=(This Year Revenue−Last Year Revenue)/ Last Year Revenue×100

YOY%=120−100100×100=20%

So revenue grew 20% compared to last year.

Total Revenue = SUM(Sales[Revenue])

Last Year Revenue = CALCULATE([Total Revenue], SAMEPERIODLASTYEAR('Date'[Date]))

YOY % =
DIVIDE([Total Revenue] - [Last Year Revenue], [Last Year Revenue], 0)

Imagine you earned ₹10,000 last year and ₹12,000 this year.

First you ask: “How much more?” → ₹2,000.
Then: “Compared to last year, what % is that?” → ₹2,000 ÷ ₹10,000 = 20% growth.

That’s exactly how businesses read YOY growth.

FBergamaschi — Wed, 24 Sep 2025 14:42:22 GMT

This is a blog for asking for support, if you want to explain DAX you can consider other blogs

lbendlin — Sat, 27 Sep 2025 23:23:05 GMT

This will fail spectacularly when the values have different signs or when one or both of the values are zero.

Sania-F — Sun, 28 Sep 2025 13:57:37 GMT

Thank you for your input , will try to consider the cases that you gave and rewrite.