Forum Discussion
Solved
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 ...
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
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
