Forum Discussion
Filtering by dates in two columns
I have a set of data that looks like the below table. As you can see it has two date columns, the settlement (when it was bought) and the maturity (when it was sold). I would like to be able to ...
I think there is a misunderstanding, but I agree with your point regarding OR. The synching of slicers is causing less results to show up when my end goal is to have more. In the above data, when I synch slicers and enter date range 5/15/22 to 5/21/22, nothing shows up. I want everything to show up.
Currently, the maturity date is the field that has a relationship with my calendar table. The ideal solution is one slicer to enter a date range, and it shows all data that has a maturity date within that range OR a settlement date within that range.