Forum Discussion
Establish Active relationship between multiple columns from two table
You can join the tables in the Query, depending on the context of your data you would need to pick the appropriate join (Left, Inner, Full Outer). These are basic SQL join parameters. Website for details here:
https://www.w3schools.com/sql/sql_join.aspIf you want to create this relationship you have 3 options:
1) Joins [Left, Inner, Full Outer] in Power Query
2) Summary tables to make distinct keys for relationships to tables
3) DAX - USERELATIONSHIP function that was mentioned above.
Understood, negi007 answers this question then. Another option is to join the tables together or create a unique table with the primary/foreign key relationship and link that to both of the related tables. PowerBI does not allow for multiple relationships between the same tables.
any other ways other than using DAX