topic Re: Percentage change analysis per item in DAX Commands and Tips

Percentage change analysis per item

hosea_chumba — Sat, 26 Nov 2022 06:02:57 GMT

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

Re: Percentage change analysis per item

lbendlin — Sun, 27 Nov 2022 16:43:01 GMT

Re: Percentage change analysis per item

v-zhangti — Mon, 28 Nov 2022 03:08:37 GMT

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.