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...
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.