cancel
Showing results for
Did you mean:
Highlighted
Post Prodigy

## Copy match vakues feom one table to another

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: Copy match vakues feom one table to another

hi, @Route11

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Anonymous
Not applicable

## Re: Copy match vakues feom one table to another

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.

Community Support

## Re: Copy match vakues feom one table to another

hi, @Route11

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Prodigy

## Re: Copy match vakues feom one table to another

many thanks experts. much appreicated

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors