mquery question

[Anonymous]

I have two tables.    Sales.    SalespersonDim.  

My SalespersonDim table has unique values (salesperson name)....but does not exist on my Sales table.   

Using Mquery, how can I add the Salesperson column  (the only column on the SalespersonDim table) to my Sales table? 

[camargos88]

@Anonymous ,

Can you give us example of how the sales table are modeled ?

It can be done using m code (using advanced editor) or by the UI like @amitchandak said.

[amitchandak]

@Anonymous , see if merge can help

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Anonymous]

@amitchandak   Merge will not work.   No matching columns to reference.   Which is why I asked about mquery.