Is it possible to use "Between" date slicer to filter other date columns?

[ERing]

I have a new requirement that I'm struggling to overcome. I have data with three date fields/columns for each record (Begin_Date, Working_Date, End_Date). I have a between date slicer on Working_Date, allowing users to select a range.

What I need is a way to apply the slicer selections to the Begin_Date and End_Date. My criteria needs to be Begin_Date is < "first slicer selection" Working_Date and End_Date> "second slicer selection" Working_Date.

In the example below, the criteria would look like Begin_Date<10/1/2023 and End_Date >10/31/2023.

[v-tianyich-msft · Accepted solution]

Hi @ERing ,

Sure.I made simple samples and you can check the results below:

Measure = var _strat = MIN('DimDate'[Date])
var _end = MAX('DimDate'[Date])
RETURN CALCULATE(COUNTAX('Table',[ID]),FILTER('Table',[Date]>_strat && [Date]<_end))

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[LokambaTH]

Hi,

1. Create Measures for Slicer Selections:
MinSlicerDate = MIN(table[Working_Date])
MaxSlicerDate = MAX(Table[Working_Date])

2. Create Calculated Columns or Measures:

• For the Begin_date:

Filtered_Begin_Date =
CALCULATE(
MAX(Table'[Begin_Date]),
'Table'[Working_Date] >= [MinSlicerDate]
)

• For the End_date:

Filtered_End_Date =
CALCULATE(
MIN('Table'[End_Date]),
'Table'[Working_Date] <= [MaxSlicerDate]
)

3. Use the Filtered Dates in Visuals

[ERing]

@LokambaTH I'm getting this message when trying to create the measure for Filtered_Begin_Date.