Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
73 | |
69 | |
35 | |
27 | |
26 |
User | Count |
---|---|
96 | |
94 | |
54 | |
45 | |
42 |