Forum Discussion
Helper IIICohort Performance but get difference between months and not from the first transaction month
Super UserMike282 , I have made a similar attempt
Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsg
Helper IIIThanks amitchandak . This is great and makes total sense. I've already been able to calculate these retention % already. What I'm specifically after is a measure that can calculate the difference between the rentention %.
I'd be after the % difference between Month 0 (the first purchase month) and Month 1 (the 1st month after their first purchase month) then month 2 then month 3 and so on. So if you take my screenshot in the opening of the thread. Let's take the December 2009 Cohort's rentention rate:
I've taken the first 6 columns of the first row and put it in a table below:
| Month 0 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 |
| 100% | 35% | 33% | 43% | 38% | 36% |
What I'm after is the % or difference between the months. So from the above table I'd be after:
| 0-1 month | 1-2 month | 2-3 month | 3-4 month | 4-5 month |
| -65% | -2% | 10% | -5% | -2% |
Just can't get this measure to work.