Mixing date and text in a measure

[Clint]

Hello,

I've a request to show "N/A" when a project doesn't have a value for the field GLIA1Complete (which is a date field).  I'd prefer to do this with a measure like:

Blank Approval (NA) =

IF(ISBLANK(

MAXA('Projects'[GLIA1Complete])),"NA",

MAXA('Projects'[GLIA1Complete])

)

The problem is, when there is a date value for that field (list of projects filtered by slicer), it returns a numeric string instead of the date.  I'm not sure how to conver this result to the proper date.  

Any insight is appreciated.

[Ashish_Mathur · Accepted solution]

Hi,

Does this work?

Blank Approval (NA) = IF(ISBLANK(MAXA('Projects'[GLIA1Complete])),"NA",FORMAT(MAXA('Projects'[GLIA1Complete]),"dd/mm/yyyy"))

[Clint]

Hi @Ashish_Mathur ,

Yes, perfectly.  thank you.  Have not used format much so this was a good learning experience.  Thank you!

[Ashish_Mathur]

You are welcome.