Percentage change analysis per item

[hosea_chumba]

Take the example below, how do i compute the percentage change of client loan amount for each client ID from one cycle of loan to the next cycle.

Client ID	Cycle of loan	Loan Amount
X	1	200
X	2	450
R	1	20,000
R	2	4,500
R	3	34,000

[lbendlin · Accepted solution]

[v-zhangti · Accepted solution]

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.

[lbendlin · Accepted solution]