Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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) | ||||||||
Year | Month | Initial | 1M | 2M | 3M | 4M | 5M | 6M |
2015 | 7 | 1,648 | 822 | 734 | 690 | 640 | 610 | 596 |
2015 | 8 | 1,498 | 776 | 711 | 656 | 626 | 610 | |
2015 | 9 | 1,515 | 787 | 657 | 643 | 620 | ||
2015 | 10 | 1,498 | 721 | 659 | 638 | |||
2015 | 11 | 1,377 | 717 | 682 | ||||
2015 | 12 | 1,398 | 741 | |||||
2016 | 1 | 1,467 |
If my distinct Customers in July 2015 are 1,648, only 822 are retained out of those 1,648 after 1M(1month) and so on and so forth.
Similarly for subsequent months distinct customers are calculated and further calulations of retention are done based on the Initial Data.
Can someone please help me with the DAX functions and the method to proceed further.
Thanks,
Kanchan
Hi Dear
Where can I found the answer of your question?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort-AND-Slicer/m-p/391883#M130
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 ,
Hi @Anonymous
How did you progress with this, am looking at doing the same?
sue
@Anonymous ,
If my distinct Customers in July 2015 are 1,648, only 822 are retained out of those 1,648 after 1M(1month) and so on and so forth.
Similarly for subsequent months distinct customers are calculated and further calulations of retention are done based on the Initial Data.
Can someone please help me with the DAX functions and the method to proceed further.
Actually you have clarified your table structure very well. In addtion would you please tell me what's the expected value? Are you trying to calculate come percentage like increase rate or decrease rate? To be general, you may refer to quick measure about how to create measures using DAX function in power bi to achieve what you want.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yuta-msft The table shown in my post is what my output should be. I have distinct customernames for past 6 months(Months are selected dynamically based on current month).
I checked quick measures also but could not find anything that could be used directly for this scenario. This is a quite complicated scenario.
Please let me know if you know what functions could be used.
Thanks!
Kanchan
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Note, Notifications are not working right now, so if you update this with data, please send me a Private message.
Hi @Greg_Deckler
I'm Interested in (Cohort analysis post) but I didn't understand your answer completely, where can I found the complete article (post) answer regarding cohort analysis?
@Greg_Deckler Thank you for sharing the link.
I will make sure I follow all these basic rules while posting any questions in future 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |