Forum Discussion
Table Date Filter
I am working on creating a filtered table based on date ranges defined by a slicer value. From the Slicer I determine the [FilterStartDate] and [FilterEndDate] in the measures at the bottom. When I...
Calculated tables are only calculated during data refresh, they don't pay any attention to slicers or filters. If you need something to react dynamically to silcers and filters you must do it in a measure
I tried building a calculated column inside the table provided a true/false if it met. This will only return "true" When I replace [FilterStartDate] with Date(2023,01,01) the filter works. Am I not able to put a measure into the column formula to make it dynamic. I'm pretty sure I have done this in the past.
FilterStart =
If(
Datevalue( [EstShipDate]) > Datevalue([FilterStartDate]) , true, false)
No, that won't work. Calculated columns are the same as calculated tables, they are only calculated during data refresh and so they cannot take account of filters or slicers.