How to have 1 table filter another table by connecting to a date table?

[bryn987]

I have 2 fact tables, both which have a relationship to 1 date table.  I need to be able to have 1 fact table filter the other fact table.

How can I do this? 

[TomMartens]

Hey @bryn987 ,

one way you can achieve this is to set the cross-filter direction of the one-to-many relationships between the data and fact table to both. This enables the fact table to filter the other fact table via the date table.

Please be aware that the bi-directional cross-filtering is considered not being a best practice, for this reason do some research.

Hopefully, this helps to tackle your challenge.

Regards,

Tom