topic Re: Date Slicer Filters Date1 OR Date2 in DAX Commands and Tips

Date Slicer Filters Date1 OR Date2

joechristo — Fri, 05 May 2023 11:00:23 GMT

I am creating a report that look sat two dates; Date1 and Date 2. I am trying to create a filter that looks at a selected date range and determines whether Date1 OR Date2 falls within that range.

i.e. a customer can select a date range 01/01/2023 - 15/01/2023 and all these records would appear in the table:

Record	Date1	Date2
1	01/01/2023	05/01/2023
2	15/12/2022	10/01/2023
3	04/01/2023	02/02/2023

Is that possible? I am struggling because of the limits of passing selected values into dax columns, and there are no set periods where a customer might be looking between records.

Re: Date Slicer Filters Date1 OR Date2

Mahesh0016 — Fri, 05 May 2023 11:16:49 GMT

joechristo Please Share you expected output.

Re: Date Slicer Filters Date1 OR Date2

joechristo — Fri, 05 May 2023 11:46:44 GMT

I want a report page with a table and filter like this:

Where the table is filtered so that either Date Appeal Determined or Date Decision Issued falls within the date range specified in the slicer

Re: Date Slicer Filters Date1 OR Date2

Mahesh0016 — Fri, 05 May 2023 12:07:16 GMT

joechristo you want to date slicer fliter Only one of date column

Re: Date Slicer Filters Date1 OR Date2

joechristo — Fri, 05 May 2023 12:52:31 GMT

For this report I need two. Is there any way to do it? In our previous reporting software this is what is implemented and we need to reproduce it.

Re: Date Slicer Filters Date1 OR Date2

Gokul_G16 — Fri, 05 May 2023 13:54:03 GMT

Hi joechristo ,

Pelase find the below snap to get you know the details.

Regards,
Gokul

Re: Date Slicer Filters Date1 OR Date2

joechristo — Fri, 05 May 2023 14:25:08 GMT

Hi Gokul, this isn't what I'm asking. This is regarding two separate date fields, not two dates in the same date field

Re: Date Slicer Filters Date1 OR Date2

FreemanZ — Sat, 06 May 2023 13:04:59 GMT

hi joechristo

Supposing you have a data table like:

1) plot a slicer with a dates table like:

dates = CALENDAR( MIN( MIN(data[Date1]), MIN(data[Date2])), MAX( MAX(data[Date1]), MAX(data[Date2])) )

(or you create the date table in other ways)

2) try to plot a table visual with all the columns, but filter that visual with a measure like:

measure = VAR _max = MAX(dates[date]) VAR _min = MIN(dates[date]) VAR result = IF( OR( MAX(data[Date1])<=_max&&MAX(data[Date1])>=_min, MAX(data[Date2])<=_max&&MAX(data[Date2])>=_min ), 1, 0 ) RETURN result

3) choose value 1 for the measures

it worked like: