Forum Discussion
Creating relationship based on two columns possible?
Hey all,
I'm used to combining two or more columns into one when I have no unique identifier. I remember that I've seen the possibility in the CreateRelationship window in PowerBI to select a 2nd column for the relationship. Same as creating a join in SQL, I would have to add a 'and' to the join to add a 2nd matching column.
I've tryed to do this in PowerBI but I am not able to select a 2nd column. This feature was possible right? I'm quiete sure i've seen it.
In the sample below you see a red number, this is how it looked like when the possibility was there to select a second column.
You might be thinking of Power Query, where it is possible to do a join on multiple columns I think, but its never been possible to create relationships that way. You'd have to combine the columns into one and use that as the key for the relationship.
2 Replies
You might be thinking of Power Query, where it is possible to do a join on multiple columns I think, but its never been possible to create relationships that way. You'd have to combine the columns into one and use that as the key for the relationship.
