topic Filter in date interval in DAX Commands and Tips

Filter in date interval

Anonymous — Fri, 16 Aug 2019 11:32:16 GMT

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?

Re: Filter in date interval

Anonymous — Sun, 18 Aug 2019 16:02:27 GMT

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

Re: Filter in date interval

Anonymous — Mon, 19 Aug 2019 11:02:32 GMT

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