When we set relationship, only can be performed for a single column in PBI Desktop. i think PBI can provide multiple column Join functions and different Join cardinality (= , >= , <= or between) in t...
This would also be great to have joins based on an OR function. for instance joining a table used to implement RLS to a fact table (f) where the user(u) is either the salesperson or the engineer for a customer: u.userId = f.SalespersonId or u.userId = f.EngineerId. Functionality to join tables on moren then fact.key1 = dim1.primaryKey should be possible.
