Forum Discussion

astano05's avatar
astano05
Icon for Helper III rankHelper III
6 years ago
Solved

Use Date Value in a Measure

I have a database then is updated daily Mon-Sat (not Sunday).  I have this measure to get the last updated date: Last Update = SWITCH (weekday(today(),2) ,1,today() -2, today()-1)   I also have a ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    astano05 - Generally MIN or MAX but I'm not sure I am visualizing your data correctly.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

astano05 - Generally MIN or MAX but I'm not sure I am visualizing your data correctly.

  • astano05's avatar
    astano05
    Icon for Helper III rankHelper III
    6 years ago

    that worked thank you!! 

     

    I now have the measure as TRUE on the correct date. However, I'm now realizing that I can't pull the measure in as a slicer or as a filter on the table. Is there anything I can do to filter the table for only the TRUE value without creating it as a column? (I cannot create columns in this database due to org security reasons)