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.
Hello All,
I am trying to perform a Cohort Analysis.
My Dataset looks as follows:
Desired Output is the percentage remaining over time:
How to create a dynamic Measure that is able to change no matter what the cohort is. Meaning if I were to switch the start date for state or anything like it, I am able to see the decay over counter.
Please help! stuck for weeks.
Solved! Go to Solution.
In this scenario, I don't know what your MRR mean and how your percentage remaining calculate.
But basically, you need to have to full calendar table and build relationship between monthly counter and date column. Then you can create a matrix, put StartDate as row group and Date on column group. If you want to use current MRR divide by total MRR under same StartDate. You can create a measure below and put it in Value.
= SUM ( Table[MRR] ) / CALCULATE ( SUM ( Table[MRR] ), ALLEXCEPT ( Table, Table[StartDate], Table[UniqueId] ) )
Regards,
In this scenario, I don't know what your MRR mean and how your percentage remaining calculate.
But basically, you need to have to full calendar table and build relationship between monthly counter and date column. Then you can create a matrix, put StartDate as row group and Date on column group. If you want to use current MRR divide by total MRR under same StartDate. You can create a measure below and put it in Value.
= SUM ( Table[MRR] ) / CALCULATE ( SUM ( Table[MRR] ), ALLEXCEPT ( Table, Table[StartDate], Table[UniqueId] ) )
Regards,
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 |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |