Forum Discussion
How to Join two tables using two column
I need to Join two tables using two columns .
My data Looks Like below.
I need to Join table 1 and Table 2 using Week ending and programme name column
You cannot do that in the Power BI data model. You can in Power Query, which is where the modeling happens, and it works there just like it would in a relational database (left join, right join, inner, anti, etc.)
In the data model, you can only have one active relationship at a time. You can have inactive relationships that you activate with DAX functions (USERELATIONSHIP()) for example, but these are not joins.
If you need to do it on 2 or more columns, you need to create a concatenated column that has both fields merged into a single column, then create the relationship on that column.
2 Replies
I generally simply create a column in each that concatenates my two or three columns into a more or less unique key.
You cannot do that in the Power BI data model. You can in Power Query, which is where the modeling happens, and it works there just like it would in a relational database (left join, right join, inner, anti, etc.)
In the data model, you can only have one active relationship at a time. You can have inactive relationships that you activate with DAX functions (USERELATIONSHIP()) for example, but these are not joins.
If you need to do it on 2 or more columns, you need to create a concatenated column that has both fields merged into a single column, then create the relationship on that column.
