Lost Customer and Recovered customer

[nmhung49]

Hi everyone,
I have a table and I would like to get the lost customers and Recovered customer

I'm having difficulty in writing formulas for Lost customers and Recovered customer dax

For example, as shown below

Please see the attached file

I'm looking forward to your reply

Thank you in advance

[amitchandak]

@nmhung49 , What is a recovered customer, How you define that. Yet to check the file, But want to be sure on logic.

Usually, we logic around isblank to get new and repeat

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

[nmhung49]

@amitchandak wrote:

@nmhung49, What is a recovered customer, How you define that. Yet to check the file, But want to be sure on logic.

---

Lost customers: the number of customers whose last purchase occurred at least 1 months before the start of the current period

Recovered customer: The number of customers who were considered lost in a previous time period, and then made a purchase in the current period.

[v-yingjl]

Hi @nmhung49 ,

Since need to sign in to open the attached file by yours. Please consider re-sharing it again for further discussion.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nmhung49]

I'm sorry, Please see the attached file

https://drive.google.com/file/d/1JZuvvjqzMccLkqkLydJBBjez5YFtUVMh/view?usp=sharing 

[Ashish_Mathur]

Hi,

I have worked on only lost customers and their sales.  Please check the results thoroughly.  My answer is different from yours but i think i am correct.  You may download the PBIf ile from here.

Once you confirm that my answers are correct, I will work on recovered customers and their sales.

[nmhung49]

Thank you for your help
Your results are incorrect
I want the result like the image below

https://drive.google.com/file/d/1JZuvvjqzMccLkqkLydJBBjez5YFtUVMh/view?usp=sharing 

Thank you

[Ashish_Mathur]

Hi,

In April, why are you not considering "d" as a lot customer.  The last sale to him was in Feb 21.  Also, in March, why are you not considering "a" as a lot customer.  The last sale to him was in Dec 20.  In Feb, why is "a" not a lost customer.

Also, in your second post, you mentioned that "Lost customers: the number of customers whose last purchase occurred at least 1 months before the start of the current period".  From this i interpret that in April 2021, lost customers would be those whose last sale was anytime prior to Feb 1, 2021.

Please clarify the logic and expected result once again.

[nmhung49]

@Ashish_Mathur 

I'm sorry, I explained late

Let me explain again that

Lost customer means that customer has not purchased within 1 month, if a customer buys a product in January but does not buy it in February, it is counted as a loss.
For example, if customer "a" is a customer who made a first purchase in January but did not purchase in February, it will be counted as lost and purchased in March as recovered, if purchased again in April, it will be counted as repeat.
If I don't buy it in May, it will be counted as lost and continue like that
Please see the result as shown below

Download File

https://drive.google.com/file/d/1kTPEmBzxo5wuUXHQ2fncA237Qfwy3W5r/view?usp=sharing 

[Ashish_Mathur]

You've replied after a long time.  Please start a new thread.