Add a new column with a value from another table

Question

Hi,&nbsp;&nbsp;This should be so simple to do but I am not getting the results I want.&nbsp;&nbsp;I would like to add a new column to a table I have created - Account Table. This table has one column - Account Code. The Account Code is taken from the Budget Table.&nbsp;&nbsp;I would like to add a new column to the Account Table called Account Desc. This is the account desc from the Budget Table.&nbsp;&nbsp;I have a relationship between the two tables on Account Code&nbsp;&nbsp;&nbsp;

goncalogeraldes · Answer

Hello there&nbsp;yaman123&nbsp;! Ideally you can do this in Power Query with the "Merge" option, merging the two tables by the Account code and extracting Account Desc from the Budget Table.&nbsp;&nbsp;Another way is to use the RELATED() function, like so:&nbsp;New Column = RELATED('Budget Table'[Account Desc])You can find further documentation here.&nbsp;&nbsp;Hope this answer solves your problem!If you need any additional help please @ me in your reply.If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍Thanks!You can also check out my LinkedIn!Best regards,Gonçalo Geraldes

alicew · Answer

If the relationship is one-to-many, many on the Budget side, it won't work. Otherwise, use RELATED.

yaman123 · Answer

Hi,&nbsp;The relationship is one (Account Table) to many (Budget Table) . When I am using Related in a new column in the Account Table, it gives me an error and doesnt recognise the table or fields?&nbsp;

yaman123 · Answer

Hi,&nbsp;The relationship is one (Account Table) to many (Budget Table) . When I am using Related in a new column in the Account Table, it gives me an error and doesnt recognise the table or fields?&nbsp;

alicew · Answer

If you have this type of relationship, what line do you want to bring? You have several options in the Budget Table, don't you?

Forum Discussion

Add a new column with a value from another table

7 Replies

Related content

find max value based on another filtered column

How to replace one column value with another column value from another table?

Replace null values of one column to another column.

lookup value in another column

Sum column values based on another column