Forum Discussion
Advocate IIStop measure results after a specific date
Actually with my suggestion you should use MAX ( Date[Date] ) as condition not SELECTEDVALUE.
What is happening hear is that SELECTEDVALUE returns blank everywhere while MAX ( Sales[Date] ) returns blank when there is no sale which did the job (blank = blank). But it won't work if you are slicing by Date instead of MonthYear.
Advocate IIHi tamerj1
I tried what you suggested, but get the same result
Interestingly, the MAX( Sales[Date] ) seems to be returning what I was expecting.
Community ChampionActually with my suggestion you should use MAX ( Date[Date] ) as condition not SELECTEDVALUE.
What is happening hear is that SELECTEDVALUE returns blank everywhere while MAX ( Sales[Date] ) returns blank when there is no sale which did the job (blank = blank). But it won't work if you are slicing by Date instead of MonthYear.