Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Customer Churn Rate

Hi, I'm trying to calculate our customer churn rate, and I've already implemented the measures from DAX patterns: http://www.daxpatterns.com/new-and-returning-customers/ As a next step I'm tryi...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    v-huizhn-msft;

    I solved my issue in the meantime by disregarding the suggested Churn-rate measure and followed another approach, which was more simple but still correct.

     

    Used the following measure, which is in Danish:

    Churn rate (Måned) = 
VAR
AktiveSidsteMaaned = CALCULATE('Kunde Churn'[Total aktive kunder]; Dateadd(Periode[Dato];-1;MONTH))
RETURN
VAR
DageIMaaned = CALCULATE(COUNTROWS(Periode);VALUES(Periode[Måned]))
RETURN
VAR
NyeKunderIMaaned = [Total aktive kunder] - AktiveSidsteMaaned
RETURN
VAR
KundeDageImaaned = ((AktiveSidsteMaaned * DageIMaaned) + (0,5*NyeKunderIMaaned*DageIMaaned))
RETURN
CALCULATE( DageIMaaned * DIVIDE('Kunde Churn'[Churned Kunder];KundeDageImaaned)
)
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Recarding the "total amount of customers" measure, I made this measure based off "Dax Patterns - Time Patterns": http://www.daxpatterns.com/time-patterns/

Total active customers = 
CALCULATE(
	CALCULATE(
			DISTINCTCOUNT(Sales[CustomerKey]);
				FILTER(
					ALL(Period[Date]);
						Period[Date] > MAX(Period[Date]) - 'Customer Churn'[Churn Days]
									&& Period[Date] <= MAX(Period[Date])
							)
						);
				FILTER(Period; Periode[Dat] <= MAX(Sales[InVoiceDate])
				)
)

The 'Customer Churn'[Churn Days] refers to another measure that holds a table that is used to filter the amount of days the users wants to use as our "Churn Definition".

Was wondering if you can confirm it's correct Greg_Deckler ?

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Anonymous,

Could you please sahre some your sample data for further analysis?

Best Regards,
Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    v-huizhn-msft;

    I solved my issue in the meantime by disregarding the suggested Churn-rate measure and followed another approach, which was more simple but still correct.

     

    Used the following measure, which is in Danish:

    Churn rate (Måned) = 
VAR
AktiveSidsteMaaned = CALCULATE('Kunde Churn'[Total aktive kunder]; Dateadd(Periode[Dato];-1;MONTH))
RETURN
VAR
DageIMaaned = CALCULATE(COUNTROWS(Periode);VALUES(Periode[Måned]))
RETURN
VAR
NyeKunderIMaaned = [Total aktive kunder] - AktiveSidsteMaaned
RETURN
VAR
KundeDageImaaned = ((AktiveSidsteMaaned * DageIMaaned) + (0,5*NyeKunderIMaaned*DageIMaaned))
RETURN
CALCULATE( DageIMaaned * DIVIDE('Kunde Churn'[Churned Kunder];KundeDageImaaned)
)