Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter in date interval

I have one calendar table that is related to another table call "transfer". In this table "transfer" I have 2 date column. Check-in and check-out. The table calendar is related with table transfer by check-in field.

I would like to filter all record of transfer in check-in and check-out interval, but the filter happen only in field check-in (because of relationship).

How I can filter all transfer that happen in check-in and check-out interval, in the period set in slicer?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Well, instead of fiddling with the Calendar table and inactive relationships, just create 2 same Calendars and join them to the respective columns. This will solve all your problems. You'll be able to slice by check-in and check-out dates and hence, intervals.

    Best
    Darek
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      But and the slicer? How I can to filter the two periods (check-in and check-out), using the slicer.