Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello I had searched the forum but cannot find an answer, hoping someone can help.
I have multiple table entries for peoples names in table 1 and in another table 2 I only have their name once.
In the table with multiple name entries I have one row that contains their age but it is missing from the other rows and also from the other table. How do I lookup the first table and pull the age and paste in the second table please?
Thanks,
Gordon
Solved! Go to Solution.
the best way to do this is to join the tables via a one to many relationship between the names (ideally if you had a personid that would be better)
once you create that relationship you can pull data from both tables in a visual as they will be linked.
what do you need from table 1?
here is more information on how to do it;
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
Proud to be a Super User!
just the age thanks that worked a treat
the best way to do this is to join the tables via a one to many relationship between the names (ideally if you had a personid that would be better)
once you create that relationship you can pull data from both tables in a visual as they will be linked.
what do you need from table 1?
here is more information on how to do it;
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
Proud to be a Super User!
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |