filter should be applied to two fields in the same table
I have multiple fact tables sharing common dimension tables. The issue I am facing is one of the fact tables has 2 date fields DT1, DT1 as shown below . They should be filtered based on the selection on a single filter DT . That mean if select 1/1/2001 only the first row get selected , if 1/2/2001 no records will be selected.
Not sure i fully understood your solution. The date look up table looks like below . The user can select year and then the linking should happen on DT column. The difficultly I have is that i have to join to both fields in the transaction table.