IF Slicer not filtered returns the max date available

[rmeng]

I have a measure to return a value of the max date if the slicer is not filtered, however the value is blank:

Can you help me with this measure, thanks.

[tamerj1]

Hi @rmeng 

Do you have a year column in the date table?

[rmeng]

No, despite automatically creates the hierarchie. 

[tamerj1 · Accepted solution]

@rmeng 
I would recommend to add a year column but you may also try