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 all,
I am trying to show in a matrix visualization active customers by year/month. If you notice the total row for each month is not showing the sum of all active accounts, value 1 (measure) will show if that account was active through the dates it was active (startdate-enddate).
This is the measure:
MeasureEOM = if(max('Table'[EOM]),int(1),BLANK())
Where 'Table'[EOM] is the column on my table that that has the End of month date per day that the account is active.
The visualization looks like this:
This is how data looks in the table:
Thank in avdvance for your help.
can you share the sample (with the sensitive data masked) from Table?
here is an example:How to Get Your Question Answered Quickly
I added how the table looks. Thank you.
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 |