Forum Discussion
YoY Growth
I want to create the following output to check the YoY growth percentage. Can anyone help me how to do it? Thanks.
| Customer Overview | ||
| Net Customers | Growth % | |
| FY 23 | 41 | |
| FY 24 | 64 | 56% |
| FY 25 | 86 | 34% |
Hi rajivsha
You can achieve the desired result with many methods, one of them visual calculation :The formula :
Versus previous = if (SELECTEDVALUE([Year])<>CALCULATE(MIN([Year]),ALLSELECTED([Year])),DIVIDE([Sum of Net Customers] ,PREVIOUS([Sum of Net Customers]))-1,blank())percentage formatting :
Result:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
5 Replies
Hi rajivsha
As always, please provide a workable sample data (not an image), your expected result from the same sample data and the reasonign behind. Please refer to this post. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi rajivsha
You can achieve the desired result with many methods, one of them visual calculation :The formula :
Versus previous = if (SELECTEDVALUE([Year])<>CALCULATE(MIN([Year]),ALLSELECTED([Year])),DIVIDE([Sum of Net Customers] ,PREVIOUS([Sum of Net Customers]))-1,blank())percentage formatting :
Result:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
