Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
76
Views
Topic starter
Hi Mynda,
I am trying to create a measure of Last 3 Months Absence for each employee using the formulae "Absence L3M =
CALCULATE(SUM(Absence[Actual Value in Hours]),DATESINPERIOD(Absence[Start of Month],MAX(Absence[Start of Month]),-3,MONTH))
However, when I drag the measure against each employee Number- It does not show anything.
I don't know what I am missing.
Regards
Shantanu
Posted : 18/09/2019 1:34 am
Hi Shantanu,
It's difficult to say without seeing your model or PivotTable structure. You need to have the Date field, Start of Month, in the PivotTable row labels or filters (which must be filtered to a single month) for the measure to interpret the row context. i.e. what start of month is it referring to?
I would also replace MAX with LASTDATE.
Mynda
Posted : 18/09/2019 6:57 am
