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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

astano05 , not very clear you can have a column like this in your date table

 

switch( true(),
[date] =max(Table[last update at]) ,"Last Updated",
[Date]& ""
)

 

Sort it on a date and use in filter