How to calculate YOY variation, when a measure is split by column

Anonymous — Wed, 28 Aug 2024 18:45:36 GMT

Hi, i'm having a sikmple issue, I get the right value with my measure Total actual consolidated, when I add the Year in column, i get the right output, but i d'ont know how to calculate YOY, with the calculate function, and group calculation some row from the Subtotal measure are missing, i dont know why. Any help is much welcomed

subtotal actual =
if(COUNTROWS('SIG structure')=1,
CALCULATE([Total actual],
all('SIG structure'),
'SIG structure'[row index]<=Values('SIG structure'[row index])))

Total actual = sum('BG groupe'[Solde])

Total actual consolidated =
SWITCH(true(),
SELECTEDVALUE('SIG structure'[Subtotal])="0",[Total actual],
SELECTEDVALUE('SIG structure'[Subtotal])="1",[subtotal actual],BLANK())

Thks a lot

Re: How to calculate YOY variation, when a measure is split by column

Anonymous — Thu, 29 Aug 2024 01:50:10 GMT

Hi Anonymous

You can use "SAMEPERIODLASTYEAR" to get the sales for the same period last year.

For example:

Calculate the year-on-year value:

PY Sales = CALCULATE([Sales Amount], SAMEPERIODLASTYEAR('Date'[Date]))

Calculate YOY growth rate:

YOY Growth = DIVIDE([Sales Amount] - [PY Sales], [PY Sales])

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic How to calculate YOY variation, when a measure is split by column in DAX Commands and Tips

How to calculate YOY variation, when a measure is split by column

Re: How to calculate YOY variation, when a measure is split by column