Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |