Date on Card Visuals

[Anonymous]

Hey everyone.

I am creating a measure where I'm extracting a single cell value. The data type of the cell in question is date. Unfortunately, when I put the measure on a card, I'm getting the value #,0.00. However, when I try to display it on a table, I'm able to see the date. Can someone tell me what mistake I'm doing here?! 

Here's the function in the measure I've created that is intended to return a date.

IF( AND (CountTitle < AllTitle, CountOwner < AllOwners),"NA", IF(OR( counttitle< AllTitle, CountOwner > AllOwners), "NA", IF(OR(CountTitle > AllTitle, CountOwner < AllOwners), "NA", CALCULATE( VALUES(Table_owssvr[Target Completion Date]), FIlter(Table_owssvr, Table_owssvr[Owner]=SelectedOwner && Table_owssvr[ID & Title]= SelectedTitle)))))

PS : I tried putting a DATEVALUE() to the CALCULATE() part, but that doesn't help either. If I put a DATEVALUE() to the whole function, it seems to work for the Date part but then throws an error, when it is supposed to display "NA".

Any help will be much appreciated! Thanks. 

[v-yuezhe-msft]

Hi @Anonymous,

Would you please share sample data of your tables for us to analyze?

Thanks,
Lydia Zhang

[Anonymous · Accepted solution]

Lydia, 

One of the forum visitors had clarified this for me on PM. 

The reason I was getting an error was because NA is text, and  DATEVALUE can't convert text.

The fix is to replace "NA", with BLANK().

Hope this helps 🙂