YoY Growth

[rajivsha]

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%

[Ritaf1983 · Accepted solution]

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

[rajivsha]

Hi @Ritaf1983 - How would I get the same result with the financial year in columns instead of rows?

[rajivsha]

Thanks @Ritaf1983 This works for me.

[Ritaf1983]

Happy to help 🌷

[danextian]

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/1447...