topic Re: If date value is not blank return date value if date value is blank return "Text" in Report Server

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

Anonymous — Fri, 03 May 2024 19:19:40 GMT

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,

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

lbendlin — Sun, 05 May 2024 00:05:52 GMT

read about COALESCE and FORMAT.

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

Anonymous — Tue, 07 May 2024 13:12:45 GMT

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

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

Anonymous — Tue, 07 May 2024 13:14:25 GMT

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

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

lbendlin — Tue, 07 May 2024 13:21:54 GMT

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

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

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

aduguid — Tue, 14 May 2024 05:50:59 GMT

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