Use Date Value in a Measure

[astano05]

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 Calendar table. I need to create a True/False measure for If( Date Value = Last Update, True, False) so I can use it as a filter to dynamically pull daily sales from the last updated date, but I am unable to use the Date Value field without an aggregator function for the measure. 

How can I accomplish this? If i need an aggregator function on date value, which do I use? 

[amitchandak]

@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

[Greg_Deckler · Accepted solution]

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

[astano05]

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)