Link two columns from one table to same column from another table

[Anonymous]

Hi everyone, i know that powerBi doesn't allow to link more than one column from the same table. So, i would like to know if there is another way to do that. In fact, i have a table containing all information (status, start, end etc..) about my applications and another which contains the link (or mapping) between them. I would like to be able to display this mapping in a table and when i hover on an application i get the status. (Below you can see my tables and the columns i want to link)

[Anonymous]

Hi, did you find a solution for this problem? I have the same issue. 

[v-lili6-msft]

hi  @Anonymous 

Do you want "AND" or "OR" when create relationship between two tables?

Power bi doesn't allow to link more than one column from the same table.

If you want "AND", you could create a third column to combine Destination and Source column to one column, then create relationship by this column.

If you want "OR", You may try to unpivot the Destination and Source column, then create a relationship with new column "Value"

Regards,

Lin

[Anonymous]

Hi @v-lili6-msft , thank you for your answer but i don't understand when you say  "try to unpivot the Destination and Source column" do you have an example ? 

[v-lili6-msft]

hi @Anonymous 

you could refer to this blog:

https://radacad.com/pivot-and-unpivot-with-power-bi

Regards,

Lin

[AllisonKennedy]

I am hoping this will be a 1 to many when you get the link right?

In Power Query, Merge the Destination and Source column into 1 column so that the format is the same as the SourceName column in the LastPipelineRun table. Then you can create a relationship between Merged column and SourceName column.

This assumes you're not using Direct Query?