Forum Discussion
Bokchoy
Helper II
4 years agoPre set Min/Max date values in custom measures
Hi All,
I've got 2 measures that retrieve Min/Max value of my calendar table using the min/max functions. The slicer then controls the min/max values as shown below.
Im trying to create a custom Column that can filter clients based on whether they have traded between the 2 custom dates.
Custom test =
var start_ = traded_start[Traded_min]
var end_ = traded_start[Traded_max]
var calc_ = IF(CALCULATE(DISTINCTCOUNT(Client[Client_id]), filter(all(Jobs_new),Jobs_new[JOB_DATE] >= start_ && Jobs_new[JOB_DATE] <= [Traded_max])), "Traded","No Trade")
return calc_
My custom column is not working because the min/max measures become unfiltered and return the min/max of the calendar table instead of the slicer-defined values.
Does anyone know how to fix this? Thanks in advance.