Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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
@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.