Slicer range compared with another column power bi dax

[Anonymous]

Hi Team,

I have table visual in my report that filter by the slicer values with some conditions.

Slicer

We have given startdate column in the slicer

For Example, If i selected range between 1-Dec-2023 To 31-Dec-2023.

Case 1:  If EndDate  is between the slicer Range then we have to show those records in Table

Start Date                Enddate

15-Nov-2023         15-Dec-2023

For above record enddate : 15-Dec-2023 is between slicer range values (1-Dec-2023 To 31-Dec-2023) so we need to show above record in table. 

Currently it is filtering the values which seleted by slicer range dates.The problem is slicer we have given one column(Startdate) and condition has to check in another column(Enddate)

File Link: Table records_slicer.pbix

Please help me on this and didn't get thought how to solve?

Thanks,

Devansh.

[Stachu]

At the moment the slicer is set on the column Sheet1[FirstSuppStartDate], the easiest way to get the behaviour you explained is to replace it with the Sheet1[FirstSuppEndDate]. This will reset the visual, so to get the same look & feel you will need to:

• rename the field name in the visual to Date
• and switch the slicer type to between

[Anonymous]

Hi @Stachu ,

As per your suggestion,We have given Enddate column in the slicer

For Example, If i selected  Slicer range between 1-Dec-2023 To 31-Dec-2023.

Case 2( Below records also need to show in the table)

Start Date                Enddate

15-Nov-2023         10-Jan-2024

 If enddate(10-jan-2024)>selected slicer enddate( 31-Dec-2023) also we should display  because event not completed but this record  in the selected date range   so we have to display above record.

Thanks in Advance.

Deva.