Hi PBI Masters,
I was wondering if you could help me out.
I can’t get the sum of the Measure 1.
I solved the problem by creating Measure 2.
However, I would like to achieve the result in the measure 1.
Measure 1 =
VAR ActualDate = SELECTEDVALUE( Dates[Date])
VAR MaxDate = CALCULATE( MAX( Dates[Date]), FILTER(all(Dates), Dates[Date] < ActualDate && [OL RE] > 0))
VAR Result =
if ( [OL RE] = BLANK(),blank(),
CALCULATE( [OLRE TD after],
Dates[Date] = MaxDate))),
Measure 2 =
If (HASONEVALUE( Dates[Date]),
Thanks a lot!