Percentage change analysis per item

 

Hi, hosea_chumba 

 

You can try the following methods.
Measure:

Previous Amount = 
VAR _N1 = MAXX (FILTER (ALL ( 'Table' ),
            [Cycle of loan] < SELECTEDVALUE ( 'Table'[Cycle of loan] )
                && [Client ID] = SELECTEDVALUE ( 'Table'[Client ID] )
        ),[Cycle of loan])
Var _N2=CALCULATE (SUM ( 'Table'[Loan Amount] ),
        FILTER (ALL ( 'Table' ),
            [Client ID] = SELECTEDVALUE ( 'Table'[Client ID] )
                && [Cycle of loan] = _N1))
Return
IF(_N2=BLANK(),0,_N2)

Measure = 
IF ([Previous Amount] = BLANK (),BLANK (),
    DIVIDE ([Previous Amount] - SUM ( 'Table'[Loan Amount] ),SUM ( 'Table'[Loan Amount] )))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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