Creating relationship based on two columns possible?

[DeBIe]

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.

[DeBIe]

Thanks @johnt75 , you are right. I was confused with the merge function within PowerQuery. 

[johnt75 · Accepted solution]

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.