Forum Discussion
Solved
Table join - multiple columns
I have two tables joined together on 3 columns 1. Market 2. WeekNumber 3. Division Using the columns from one table only, I'd like to filter the data for a metric in the other table. However, ...
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604
Hi v-chuncz-msft , thanks for the link.
I actually ended up doing something similar by merging the columns I wanted to join and then join the tables on these merged columns.
bo_afk ,
I think you want to join on more than one column. Create a concateneated column in both tables like this
key = Market & "-" & WeekNumber &"-"& Division
and join.
Power BI mutiple joins are there to change relation using userelation. You can check my HR Anaytics blog for that. Link is in signature.