How can I Connect (create a relationship) 2 tables in Power Bi by column A in table 1 equals Column B "OR" Column C in table 2?
Note: Make sure that RLS and hierarchy still apply.
example of tables:

How can I Connect (create a relationship) 2 tables in Power Bi by column A in table 1 equals Column B "OR" Column C in table 2?
Note: Make sure that RLS and hierarchy still apply.
example of tables:
