Forum Discussion
How to Calculate YoY Growth?
Having trouble calculating YoY growth for this data set below:
I want to get % YoY growth of the Number (USD)
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!
5 Replies
- pankajnamekar25
Super User
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 | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
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-msftCommunity Support
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!
- 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.worked thank you!
