If the dates between two dates fall within the dates selected on a slicer

[jn123]

Hi there, 

I am trying to create a formula that determines if the dates between two dates in a table (Order Start Date and Order End Date) fall between the dates that are selected on a slicer. 

For Example, I have an Order Table:

When I select "This Month" (2/1/24 -2/29/24) on a slicer, I will only see Orders B, C, D, and E.

Is this possilble?

Thanks!

[jn123]

This worked!! Thank you @Greg_Deckler!! 

[Greg_Deckler · Accepted solution]

@jn123 Well, you will likely need two disconnected date tables for your slicers. Then you could do this:

Selector Measure = 
  VAR __OrderStartDate = MAX('Table'[Order Start Date])
  VAR __OrderEndDate = MAX('Table'[Order End Date])
  VAR __Date1 = MAX('SlicerDates1'[Date])
  VAR __Date2 = MAX('SlicerDates2'[Date])
  VAR __Result = IF(__OrderStartDate >= __Date1 && __OrderEndDate <= __Date2, 1, 0)
RETURN
  __Result

See: The Complex Selector - Microsoft Fabric Community