Forum Discussion
Cohort Analysis To Calculate How Many Distinct Customers Retained Every Month
Hi Everyone, I am trying to do Cohort Analysis on Customers who are retained in subsequent months.Please see the below excel which needs to be created in Power BI Customers (Count) ...
If you could share the sample data.
But this will be the steps you follow.
1. Calculate the OrderPeriod in yyyy-mm format for each transaction ,
YEAR(Query1[entryDate])&VALUE(FORMAT(MONTH(Query1[entryDate]),"00"))
2. Calculate the Cohort Group for that transaction
FORMAT(CALCULATE(MIN(Query1[entryDate]),
ALLEXCEPT(Query1,Query1[custId])),"yyyy-mm").
Then use summarize DAX function to get total customers
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly