If date value is not blank return date value if date value is blank return "Text"

[Anonymous]

Hello

I need a measure for a card visual to display a date value if present however if it's blank display a custom text such as "NONE"

The date field(expectedresultdate) is a data type of "Date". The custom text if the field is blank is just "Text".

Heres what I have.

next update = IF(ISBLANK(SELECTEDVALUE('Annual Metrics'[ExpectedResultDate])),SELECTEDVALUE('Annual Metrics'[ExpectedResultDate],"NONE"),SELECTEDVALUE('Annual Metrics'[ExpectedResultDate]))

Thank you,

[lbendlin]

read about COALESCE and FORMAT.

[Anonymous]

All I want is the date value to return(no calculations, just return whats there) and if it is blank return text "NONE".

[lbendlin]

You can't. You need to format the date as text first.

COALESCE(FORMAT([Date],"yyyy-mm-dd"),"NONE")

[Anonymous]

This didnt help. I tried coalesce it did not return my text "NONE"

[aduguid · Accepted solution]

=IIF(IsNothing(Fields!date.Value), "NONE", FORMAT(Fields!date.Value,"yyyy-MM-dd"))