Forum Discussion
JamesMarquezDev
5 years agoFrequent Visitor
Variable Date from Measure Not Working in Filter Function
Why does hardcoding a date in the filter function result in a correctly filtered table: Filtered Table =
FILTER (
table,
table[date_column] >= DATE(2021,5,1)
) However, u...
JamesMarquezDev
5 years agoFrequent Visitor
I verified that your response is correct. To test it, I created a new Calendar table with a date range smaller than the original Calendar table, and it worked correctly. The new table was being filtered by the variable MIN date in the new test Calendar. If I want to allow my user to dynamically change the date range of the Calendar table without using a slicer, are there any other methods to allow a user to dynamically change the date range of the Calendar without using slicers that will still work correctly in DAX formulas with variables?