Forum Discussion
Helper IIPre 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.
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.
3 Replies
- vojtechsima
Super User
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.
BokchoyHi 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
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.