Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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 "Da...
Date
DAX
measure
Text
visual card
  • aduguid's avatar
    aduguid
    2 years ago

     

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

read about COALESCE and FORMAT.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

     

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