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 "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,

 

 

 

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"))

5 Replies

    • 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
        Memorable Member
        2 years ago

         

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

    • 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
        Super User
        2 years ago

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

         

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