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

[Anonymous]

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

1. subtotal actual =
2.  
3. if(COUNTROWS('SIG structure')=1,
4. CALCULATE([Total actual],
5. all('SIG structure'),
6. 'SIG structure'[row index]<=Values('SIG structure'[row index])))
7.  

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

2

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

Thks a lot

[v-jialongy-msft · Accepted solution]

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.