% change over instalments (not dates)

[s-turn]

Hello, I wonder if it's possible to calculate percentage change over sequential numbered instalments, which are not dated?  The idea is that customers sign up to an open-ended plan and might cancel at any point.  I want to compare the number of customers who make their first payment to the number who make their second, third etc.

Here's a mock-up from Excel:

i.e. only 58% of customers make 6 or more payments, and 95% of those who make 5 payments will go on to make a sixth payment, etc.

Thanks in advance!

[v-deddai1-msft]

Hi @s-turn ,

Would you please show us some sample data of your raw data? Then we can help you more accurately.

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

Best Regards,

Dedmon Dai

[HotChilli · Accepted solution]

If you store the table as 2 columns . (instalment and makeP)

Then add 2 calculated columns as follows:

ColumnA = VAR _prevP = LOOKUPVALUE(TableQ[makeP], TableQ[instalment], TableQ[instalment] - 1)
RETURN
    DIVIDE(TableQ[makeP] , _prevP) 

ColumnB = VAR _prevP = LOOKUPVALUE(TableQ[makeP], TableQ[instalment],  1)
RETURN
    DIVIDE(TableQ[makeP] , _prevP) 

Please post sample data next time (not a picture). It always helps.