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.
I have following measure that calculates the version accross dates (displayed in green below).
Version =
VAR endOfMonthDate = ENDOFMONTH(Dates[Date])
VAR startOfMonthDate = STARTOFMONTH(Dates[Date])
VAR lastDate_ = CALCULATE(LASTDATE('Upgrade_Data'[UpgDate]),
'Upgrade_Data'[UpgDate]<=endOfMonthDate,
CUSTOMERS[LEAVE_DATE] >= startOfMonthDate || CUSTOMERS[LEAVE_DATE] = BLANK())
return
CALCULATE(
[MaxCustomBranch],
'Upgrade_Data'[UpgDate] = lastDate_
)
Now I want to have following output.
I have spent quite some time on it. But not able to count the values generated by measure. Can anyone please help ?
Hi @vaibhavd
If you want to use a version in your Matrix as a Column or Row then you will need to add it as a column to your table.
If this is not what the problem is, please can you attempt to explain it again?
Thanks
Mariusz
Hi @vaibhavd
not sure thi is you are looking for but try a measure like
Measure =
var countCustomer = calculate(count(Table1[Customer]))
return
if(isblank(countCustomer);0;countCustomer)
it could give you a desired matrix
do not hesitate to give a kudo to useful posts and mark solutions as solution
Please help me on this.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |