Value if Blank- Date

[jimmyg706]

Morning All

Maybe its too early for my brain.

I have a date field which to get a date it was parsed etc. thats not the issue.

I have blanks in this field.  So Im going to do a DAX that will say if Blank  No date  is added

If true then I wanht to see the date

Current

Due Date

01/01/2023

01/01/2024

Expected

Due Date

No Date

01/01/2023

No Date

01/01/2024

Appreciate any advice

Jimmy

[Ahmedx · Accepted solution]

Try this

= IF(table[A] ="","NO DATE",table[A]&"")
OR
= IF(table[A] =blank,"NO DATE",table[A]&"")
or
= IF(ISBLANK(table[A] ),"NO DATE",table[A]&"")