Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

New Customer buying for next months

Hello All,

I need help in creating a query for my desired requirement.
I need the below report to be made in Power BI.

Column B / Row 71 - (9478) Are the new customer for July-21
Column B / Row 72 - (27816)  Are the repeat customer for July-21

Column C / Row 71 - (1979 out of 9478) Are the new customer of July-21 who has also purchased in Aug-21
Column C / Row 72 - (14734 out of 27816) Are the repeat customer of July-21 who has also purchased in Aug-21
Column D is the retention % for both new and repeat customer

Column E / Row 71 - (1670 out of 9478) Are the new customer of July-21 who has also purchased in Sep-21
Column E / Row 72 - (14535 out of 27816) Are the repeat customer of July-21 who has also purchased in Sep-21

and so on...
for rows 75 and 76 is the same thing as above for Aug-21
for rows 79 and 80 is the same thing as above for Sep-21

and so on for 
Capture.PNG

Please help me with this solution as I am new to Power bi and I am unable to make it.
I have Bill ID, Customer ID. Bill Date and Sales in my data.
You can use sample data for the solution.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

2 REPLIES 2
Anonymous
Not applicable

amitchandak
Super User
Super User

@Anonymous , see if the approach in these blogs can help

 

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

 

next month is +1 month in dateadd or nextmonth

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.