% Change of this year vs previous years

[Anonymous]

Hi Team,

Need to solve the below and requried ur help.

I need to show the % change from current year vs previous year. Below is the proble and the outpu required.

Year	qty		
2017	10		
2018	20		
2019	30		
			
			
Year	qty	% Chage	Logic
2017	10	0%	
2018	20	50%	(10-20)/20
2019	30	67%	(20-30)/30

Thanks,

Raj

[v-yuaj-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, you can create a measure as follows.

Measure =

var x1=MAXX(FILTER(ALL(Qty),[Year]=SELECTEDVALUE(Qty[Year])-1&&[Year]>=2017),[qty])

var x2=IF(MAX('Qty'[Year])=2017,MAX('Qty'[qty]),x1)

return

FORMAT(DIVIDE(MAX('Qty'[qty])-x2,MAX('Qty'[qty])),"percent")

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

There is no pbix file there,

[Ashish_Mathur]

Hi,

There is.  See bottm left in the image

[Anonymous]

Hi Ashish,

I am not able to find the file.

Regards,

Raj

[Ashish_Mathur]

That is the file (in the image).  Just download it.