Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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?
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?
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.
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?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |