I want to add a column from another table

[Wengel]

Hi, 

Ive been trying to search the community for answers but havent found the rigth solution yet. 

I have two tables and in both tables the i have a column with order numbers, i have a realtionship many to many. 

In one of the table there is a field called "created by" (which tells what person have created the order). I want to add that column to the other table every time the order numbers match.  So if a order number have a created by it writes the created by person in everytime the number accurs. (So i kinder want a match formel for it)

Its automatic O-DATA i use, if that is relevant. 

Hope it makes sense and there is a solution. 

[Wengel · Accepted solution]

I found the solution. i used this formel

Created by= Calculate(Firstnonblank('table A' [Created by],1),FILTER(ALL('Table A'),'Table A' order number='Table B' Order number))

[Fowmy]

@Wengel 

Add the following Column in  Table A

User ID - B - LOOKUPVALUE ( Table B[Created BY] , Table B[ User ID] , Table A[ User ID] ) 

[Wengel]

Didn't know the lookup could work, but i get an error "A table of multiple values was suplplied where a single values was expected), I have removed duplicates from table B so there should only be one of each order number, but in table A there are more then one of each number, since it tells what cost account they go in to.