Use date slicer to filter two columns before and after.

[nbarsley]

Hi, 

I'm trying to figure out how to use a date slicer from a generated date table to filter two columns in a table for different ranges. 

SQL Example: 

SELECT date1, date2, amount

WHERE date1 > (slicerdate) AND date 2 < (slicerdate) 

The closest I've come to making this work is by using a measure to create an if statement for the condition, then filtering the table based on the condition. But this only works when displaying both dates in the table. Any suggestions for a different approach? 

[audreygerred]

Hi! Try out this YouTube video from David Benaim. It should help you get where you need to be: https://youtu.be/pQ9eSnfAhnc?si=PcKONjNkg_mNvulR