For the (Customer Retention And New Customers Calculations) showcases how can we calculate the customer retention rate as the following:
Customer Retention Rate = ((E-N)/S)*100
Where:
Number of the customer at the end of a period (E)
Number of new customers acquired during that period (N)
Number of customers at the start of that period (S)
Could you please share with us how can we model it? and If Possible how to calculate the Customer life time value (LTV)?
Can you show me the specific example you’re working on? Where you are at with it?
If you are looking for a specific video tutorial I recommend requesting it through the ‘Content Ideas’ section and then I’ll review it and see when I can get this into the schedule
Ok Sam thank you so much , here is the where I got this formula : http://customersthatstick.com/blog/customer-loyalty/how-to-calculate-customer-retention-rate/ , I’m putting
The Topic In this section because the Show Case Is already available and Not New (New Customer and customer churn Showcase), In the future I’ll consider this and Sorry if I put the topic in the wrong section.
Certainly if you are working on something live and you need some help in a certain situation like with you DAX formula, your model etc, then always post that.
Training materials etc. just take a lot of time to create from scratch in some cases and I have a list of about 200 things that I could cover. It’s just about prioritizing time.
Obviously the support forum is here though to support development work and direct members to where to learn and master everything to do with Power BI.
Ok I’ll try to work with it by myself but Can I get a tip from You On How to calculate it based on any of related Videos (Customer Churn and/or attrition) ?
I mean from Lost , New and retained customers that were showed in your show cases?
CE [Total Customers] , CN[New Customers] and I created a new measure called [last Period New Customers] = CALCULATE([New Customers],DATEADD(Dates[Date],-1,MONTH)
Where [last Period New Customers] is CS, But I found the Rentintion Rate is Very High starting from Sep 2016 and later months , based on what I did do you think the Calculated Rentention Rate is correct ? if not please correct it.
Ok Now I think what you said is the right thing divide the steady by total customers , so it’s over now thank you for that , Now I need Just to understand the concept of Customer Lost Revenue if you don’t mind.
What it’s doing is saying how much that particular customer purchased in the proceeding 365 days (you could put this to any time frame obviously)
As they are lost and didn’t purchase anything, you need to look backwards and evaluate what they did buy and then use that as the value you considered lost.
This certainly is open to interpretation and could be situation dependent but is the logic that I used in this example.
I understand but Just please refer to the Picture for that particular customer , I understand everything Until the line with Amount (9,003) , the other two amounts line (6,979) and (5,196) still not understand how it calculated.
Hi @Rohit1
You might want to start a new topic as this posting was already solved back in 2018. If you don’t start a new topic people in the forum might not see your posting to help you.
move your mouse over the circle bottom right hand corner from the main menu it will change to state new topic. Click on the “new topic” and go from there