Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have three tables of the form:
ID | Location |
11 | NY |
12 | DL |
13 | IN |
14 | TX |
17 | NY |
ID | Weight |
11 | 1 |
12 | 2 |
ID | Lot |
17 | 2123 |
I am looking to achieve this:
ID | Location | ID Match | Weight | Lot |
11 | NY | 11 | 1 | null |
12 | DL | 12 | 2 | null |
13 | IN | null | null | null |
14 | TX | null | null | null |
17 | NY | 17 | null | 2123 |
I have created a relationship set up between the ID columns of the three tables. I want to add those rows from the second and third tables to the first table that have a matching UID.
I tried using the related function for the second table. But since I can only have one active relationship, I am not able to do the same for the third table.
Can anyone please give me any direction on how I can add rows from different tables to the first one that have a matching ID? Thanks!
Solved! Go to Solution.
Hi @anshpalash
Please download the sample file attached.
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @anshpalash ,
Whether the advice given by @VahidDM has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
Hi @anshpalash
Please download the sample file attached.
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi,
Use the Merge Queries feature of the Query Editor.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |