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
Mike282Thanks 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.