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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!