Forum Discussion

jn123's avatar
jn123
Frequent Visitor
2 years ago
Solved

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

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.  ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    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