Pre set Min/Max date values in custom measures

[Bokchoy]

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.

[vojtechsima]

Hi, @Bokchoy ,
if you want the new measure to be dynamically chosen by the two slicers, just use in your new measure following:

var mindate = MIN('Your Table'[YourDate])
var maxdate= MAX('Your Table'[YourDate])

and you're simply done.

[Bokchoy]

Hi Vojtechsima, 

Sorry, i didn't explain my question clearly. I'm trying to create a custom column, not a measure. I've updated the post

[vojtechsima · Accepted solution]

@Bokchoy 
As my knowledge goes, I don't think it's even possible and frankly, I am not sure about the actual use case.
If you need a table with dynamic value, just create the same Table as Visual and add the new measure as the column and then you have your desired Column, you can then export that table or do other stuff with it.
The Measure you used will most likely work for the desired column.