cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Cohort Performance but get difference between months and not from the first transaction month

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.

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!

2 REPLIES 2
Super User

@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

Helper III

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors