Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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. 

 

  • Anonymous's avatar
    Anonymous
    9 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

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

    Thanks,
    Lydia Zhang

    • Anonymous's avatar
      Anonymous
      Not 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 :)