How to Calculate YoY Growth?

[34583458hhdnsk]

Having trouble calculating YoY growth for this data set below:

I want to get % YoY growth of the Number (USD)

[v-kpoloju-msft]

Hi @34583458hhdnsk,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @pankajnamekar25, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.    

Output:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[34583458hhdnsk]

worked thank you!

[pankajnamekar25]

Hello @34583458hhdnsk 

You can use this measure

YoY Growth % =

VAR CurrentYear = [Total Value]

VAR LastYear = CALCULATE([Total Value], SAMEPERIODLASTYEAR('DateTable'[Date]))

RETURN

DIVIDE(CurrentYear - LastYear, LastYear, 0)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[34583458hhdnsk]

Can you help me understand why everything is 0 under YoY Growth %? (I made a new measure Total Value = SUM(Append1[Number (JPY)]) ),  Am I supposed to use Append1(Time) since my table is labeled Append1?

[v-kpoloju-msft · Accepted solution]

Hi @34583458hhdnsk,

May i know has your issue been resolved? If the response provided by the community member @pankajnamekar25, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!