Connect 2 tables in Power Bi by column A in table 1 equals Column B "OR" Column C in table 2

Viewed 50

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:

Screen shot of tables Roles and Transactions, and relationships between them.

0 Answers
Related