Customer analysis

[carlosmorales]

Hello, happy new year everyone.

I once again appear before you requesting your support.

I keep learning from Power Bi. however, I consider that some issues are still outside my capabilities, such as the following:

from the attached database, I should find the following:

1) Customers: the number of customers who made a purchase within that period of time.

2) New customers: the number of customers who made their first purchase within that time period.

3) Returning customers: the number of customers who have already bought something in the past and who return in that period of time.

4) Lost customers: the number of customers whose last purchase occurred at least 2 months before the start of the current period.

5) Recovered Customers: The number of customers who were considered lost in a previous time period and then made a purchase 

in the current period.

and present a graph like the following one for each class or type of client, filtered by category or brand.

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

Thank you in advance for your time, and for sharing your knowledge.

[carlosmorales]

Hello,
Thank you very much for answering 

@MattAllington  and @amitchandak 

Although the answers are well structured, I have a doubt; in my data there is the field: possible days of next purchase.

From the date of purchase + possible days of next purchase, I must classify the clients and their status (new, lost, etc.)

[amitchandak]

@carlosmorales , refer to my two blogs that cover this topic. Hope that can help

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...

[MattAllington]

It is all documented here https://www.daxpatterns.com/new-and-returning-customers/