Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi,
I want to have a cohort analysis of my customers which I patterned to this: https://www.youtube.com/watch?v=vbg4Je1tuis
However, I am not getting the right numbers.
Formula Used:
How can I achieve this?:
Note: I have a date table.
Solved! Go to Solution.
@Anonymous , I have discussed very similar stuff
here
Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
and here https://www.youtube.com/watch?v=Q1vPWmfI25o
Hi
The method explained in the video works fine. You need to have proper data otherwise it will show only 1 column. if you want to try then use Amit's PBIX data and use the approach and test it.
Thanks
Hari
@Anonymous , I have discussed very similar stuff
here
Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
and here https://www.youtube.com/watch?v=Q1vPWmfI25o
Thanks! This works!
User | Count |
---|---|
89 | |
88 | |
85 | |
80 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |