The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
So I've been playing around with this PBIX file provided by Linson Abah running Cohort performance this is great and I've created a version of this report for my own company.
You can download his PBIX file on github here https://github.com/databugs/cohort-analysis-with-power-bi/
There is one calculation that I want but I'm just unable to get the correct numbers. That is the movement difference between Churn rate and Retention rate between the months since first transaction. So see below image. This is the numbers I want:
So not the retention rate or churn rate compared to month 0 but the difference between the two percentages for each month since first transaction if that makes sense.
Any help would be greatly appreciated.
Thank you!
@Mike282 , 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-Anal...
Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsg
Thanks @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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
82 | |
63 | |
54 | |
52 |
User | Count |
---|---|
128 | |
115 | |
80 | |
65 | |
63 |