Customer Retention Rate

Question

Hi! I am new to analysis using Power bi and need help to analyse for customer retention. Basically, this dataset contains registration date, service date and service cost. I need to analyse for new customers, returning customers, lost and recovered customers.

The link to the data is attached.

https://www.dropbox.com/s/x6t3cxlmaqzv5jm/car.pbix?dl=0

mariusz · Answer

Hi&nbsp;flintstone&nbsp;
&nbsp;
Try this blog post.
https://www.sqlbi.com/blog/marco/2014/06/26/calculate-new-returning-lost-and-recovered-customers-in-dax/&nbsp;
&nbsp;
&nbsp;
Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me. LinkedIn 
&nbsp;

amitchandak · Answer

flintstone , try like
new vs repeat customer https://community.powerbi.com/t5/Desktop/Churn-Rate-lost-Customer/m-p/1173754#M529196https://blog.enterprisedna.co/new-vs-existing-customers-advanced-analytics-w-dax/https://www.sqlbi.com/articles/computing-new-customers-in-dax/

icey · Answer

Hi flintstone&nbsp;,
&nbsp;
Please tell us what exactly you want to achieve. Please tell us your specific requirements. This will let us to help you faster and more effectively.
&nbsp;
&nbsp;
Best Regards,
Icey

Forum Discussion

Customer Retention Rate

3 Replies

Related content

Retention Rate

How to calculate customer retention rate

Utilization Rate

Retention Rate (HR)

Retention analysis