Forum Discussion
Merge 2 tables with the same columns with different data - PowerBI (Power Query)
Hi All,
I am using Power query in PowerBI and I want to combine two tables that have the same columns into 1 query with no duplicates.
Example:
Table 2
The result should be like this:
How can I do this? thank you!
Hello Anonymous ,
this can be done in Power query using Appending queries.
check this video https://youtu.be/xl2Cc8XugHU?si=iZdDQleMUFAmPf6N
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
1 Reply
- Idrissshatila
Super User
Hello Anonymous ,
this can be done in Power query using Appending queries.
check this video https://youtu.be/xl2Cc8XugHU?si=iZdDQleMUFAmPf6N
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡