Forum Discussion
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 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?
astano05 - Generally MIN or MAX but I'm not sure I am visualizing your data correctly.
3 Replies
astano05 - Generally MIN or MAX but I'm not sure I am visualizing your data correctly.
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)
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
