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 moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |