Merge or add a column from one table to another?

[sharpedogs]

I have two tables with Cost Centers and UserID's. I want to move the details from table A over to table B. 

Table 1 - Take the users form table 2 that match table 1 and pull their Cost Center over in a new column

User	Cost Center
chad	1111
jeff	2222
mat	3333
sam	4444

Table 2

User	Cost Center
Chad	5555
jeff	6666
frank	9999
mat	8888

[Greg_Deckler · Accepted solution]

Probably:

Column = LOOKUPVALUE('Table 2'[Cost Center ],'Table 2'[User],[User])

PBIX attached 

[sharpedogs]

Hey Greg, 

This works perfect as a measure, but now that i see the measure in action i realize a measure won't work as i need to do additional transformations on these Cost Centers. So i really need it as a column, instead of a calcualted column. Thats why I was thinking something like a append or merge? 

Any ideas? I checked append and thats out of the question, merge looks a bit to much as it looks to merge all the fields?