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)
)
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft 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)
)