How to relate a column from one table to the headers of another table

[equetzal]

Hi I am have trouble finding a efficient way to link my key table to the data table as can be seen in the picture. 

And for reference please see the tables below 

As can be seen I am trying to link the Feeder PointID column to the headers of the data table 

Any assistance would be greatly appriciated. 

[selimovd]

Hey @equetzal .

where are you struggling?

You need a column with the same key in both tables. So you need the "Feeder PointID" also in the second table. Does this exist?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[equetzal]

Thanks for the reply @selimovd 

So that is my problem the way the Data table is structured no there is no similar column. The entries in the key table column are the headers in the data table I can related them one by one as can be seen below but this does not seem efficient.  

[selimovd · Accepted solution]

Hey @equetzal ,

it doesn't work like this in Power BI.

You can only have one active relationship between two tables and this relationship has to be with one column.

So the valid key is the combination of 3 columns you might want to combine them to a key column in Power Query. Something like "Column1_Column2_Column3" as your key column.

Would that work?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[equetzal]

Thanks @selimovd  I will have to modify my approch given power bi parameters