Forum Discussion
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.
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 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
2 Replies
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 __ResultThis worked!! Thank you Greg_Deckler!!
