Forum Discussion

vaibhavd's avatar
vaibhavd
Frequent Visitor
6 years ago

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 ?