Merging Tables with same Headers

[amaniramahi]

I have three tables for sales results for three different sales people.

Headers are Identical.

I need to merge the data under the same header row.

How am I suppoesed to do that?

and one more thing, I need to add a column to show the sales man who handled the sales process mentioned based on the source table.

[v-alq-msft]

Hi, @amaniramahi 

There are two primary ways of combining queries: merging and appendind. I assume that you need to append two queries. You may click 'Editor Query', go to Query Editor, select 'Home' ribbon, click 'Append Queries'. For the second question, could you please show us your sample data and expected result? Do mask sensitive data before uploading. Thanks.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amaniramahi]

Thank you all for the help.

for the second part please ignore, it will be solved if I created a unique key for each row and added some DAX.

I solved it by adding the sales man name in the excel files (source data)

[Greg_Deckler]

@Anonymous is correct on the first part.

For the second part, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous · Accepted solution]

For the first part, you would use "Append Queries" rather than mergeing them. It is all the way on the right side of the Home tab in Edit Queries.

[amitchandak]

Can you explain the second part more? For first one refer :https://radacad.com/append-vs-merge-in-power-bi-and-power-query