Filter in date interval

[faelchristofano]

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?

[Anonymous]

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

[faelchristofano]

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