Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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.
Solved! Go to Solution.
I have got the anwer in this blog
https://finance-bi.com/blog/power-bi-cohort-analysis/
I have got the anwer in this blog
https://finance-bi.com/blog/power-bi-cohort-analysis/
@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