Forum Discussion
davidcc
3 years agoNew Member
Filtering table by values from another, filtered table
I have two tables: Table A Contract (unique) | Date from | Date to 2021 | 2021-01-01 | 2022-01-01 Q1 2021 | 2021-01-01 | 2021-04-01 Q2 2021 | 2021-04-01 | 20...
ckl2022
3 years agoRegular Visitor
quick way could be to create 2 calendar tables (calendar A for the "From" filter & Calendar B for the "To" filter)
Create relationship between Calendar A & Table A (use Date From Column)
Create relationship between Calendar B & Table A (use Date To Column)
then
Create relatonship between Calendar A & Table B
Create relationship between Calendar B & Table B
Add two slicers to your visual, name the first "From Date" with Calendar A dates and the other should be "To Date" with values from Calendar B.
there is probably a more tidy way to do this,, but yeah - quick fix.