Cross-filter visualisations using inactive table relationship?

[CloudMonkey]

Hello,

Please does anyone know how to cross-filter visualisations using inactive table relationships?

(my transactions have lots of different dates (record creation date, order date, delivery dispatch, collection date etc) so I can't make them all active)

Thank you for your help,

CM

[amitchandak]

@CloudMonkey , That will work when both use a common date table so date filtered on one will pass to another

the measures can use userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...