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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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