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 to all. I'm trying to build tables for cohort analysis, and I want to make a matrix, where the percentage of users remaining in the next month with respect to the first one will be visible.
The left table is the percentage, and the right is the cohort.
I was able to restore the cohort table, but there were problems with the percent table:
This is how my data will be sent out:
Please help create a percent matrix in Power BI.
Solved! Go to Solution.
You may try the measure below.
Measure = DIVIDE ( SUM ( 'Table'[count] ), CALCULATE ( SUM ( 'Table'[count] ), TOPN ( 1, CALCULATETABLE ( VALUES ( 'Table'[cur_date] ), ALLSELECTED ( 'Table'[cur_date] ) ), 'Table'[cur_date], ASC ) ) )
You may try the measure below.
Measure = DIVIDE ( SUM ( 'Table'[count] ), CALCULATE ( SUM ( 'Table'[count] ), TOPN ( 1, CALCULATETABLE ( VALUES ( 'Table'[cur_date] ), ALLSELECTED ( 'Table'[cur_date] ) ), 'Table'[cur_date], ASC ) ) )
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |