Forum Discussion

sheetals's avatar
sheetals
Icon for Helper I rankHelper I
4 years ago
Solved

Establish Active relationship between multiple columns from two table

I have a data model as shown below where I have established relationship between two tables from two columns named orderid and itemid, but only orderid column is active Can I establish active relati...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.asp

    If 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. 

sheetals's avatar
sheetals
Icon for Helper I rankHelper I
4 years ago

any other ways other than using DAX

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.asp

If 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.