Forum Discussion
Date on Card Visuals
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.
- Anonymous9 years ago
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 :)
2 Replies
- AnonymousNot applicable
Hi Anonymous,
Would you please share sample data of your tables for us to analyze?
Thanks,
Lydia Zhang- AnonymousNot applicable
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 :)