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

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

  • aduguid's avatar
    aduguid
    Icon for Memorable Member rankMemorable Member
    2 years ago

     

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