How to Join two tables using two column

[Anonymous]

 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

[edhans · Accepted solution]

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.

[Greg_Deckler]

I generally simply create a column in each that concatenates my two or three columns into a more or less unique key.