Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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!