Forum Discussion
vaibhavd
6 years agoFrequent Visitor
Count values generated by measure across dates table.
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 ?