Month to Month Change % Formula not showing correctly

[Fidezuri1990]

Hi,

I have 3 KPIs: KPI01, KPI06 & KPI07. I am trying to calculate the month-to-month change for each KPI. As an example, Aug KPI01 minus July KPI01, and Sep KPI01 minus Aug KPI01. However, the output showed totally different values. It takes Jul KPI06 minus Jul KPI01. I attached the formula and the table. Looking forward to some advice. Thank you.

Refer to last column for the outputs.

The formula.

Thank you. 

[ryan_mayu · Accepted solution]

@Fidezuri1990 

pls try this

Column =

var _last=maxx(FILTER('Table','Table'[KPI No.]=EARLIER('Table'[KPI No.])&&'Table'[Date]=EDATE(EARLIER('Table'[Date]),-1)),'Table'[Final Assessed APS%])

return if(ISBLANK(_last),blank(),'Table'[Final Assessed APS%]-_last)