Copy match vakues feom one table to another

[Anonymous]

Hi Experts

How could you write a measure to do the following based on two tables A and B.
Table A two columns A B
Table B one column A
I want to match the customer names in table a column A with those in table b column A and return the values from table A Column B into a new column Table B.

[v-lili6-msft · Accepted solution]

hi, @Anonymous

You may try to use LOOKUPVALUE Function to create a calculate column like below:

lookup = LOOKUPVALUE(TableA[ColumnA],TableA[ColumnA],TableB[ColumnA] )

For example

tableAtableB

Result:

Best Regards,

Lin

[Anonymous]

many thanks experts. much appreicated

[Anonymous]

Hi Route11,
First of all, you should to creat a relationship between TableA[A] y TableB[A], then in Data Tab or Data Canvas creat a calculate colum in TableB, "Name Header" = RELATED (TableA[B]).

Tell us if it works for you.