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,
I have two lists like as follows:
List1 |
Team1 |
Team2 |
Team3 |
Team4 |
List 2 |
Team1 |
Team2 |
Team5 |
Team4 |
I want to use Power Query to append the two lists and then remove the duplicates. This would result in a list like this:
All |
Team1 |
Team2 |
Team3 |
Team4 |
Team5 |
Can someone help me with the syntax needed to achieve this? I'm running into problems because the fields are called different things, so Table.Combine isn't working as desired.
Thanks,
Matty
Solved! Go to Solution.
Hi @Matty
For the two lists, select "Append as new", then select "Remove rows"->"Remove duplicates".
Best Regards
Maggie
Hi @Matty
For the two lists, select "Append as new", then select "Remove rows"->"Remove duplicates".
Best Regards
Maggie
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |