Add a new column with a value from another table

[yaman123]

Hi, 

This should be so simple to do but I am not getting the results I want. 

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. 

I would like to add a new column to the Account Table called Account Desc. This is the account desc from the Budget Table. 

I have a relationship between the two tables on Account Code 

[v-janeyg-msft]

Hi, @yaman123 

Not very clear about your needs, I don't know the logic of getting Account Desc.

Can you share some sample data (hide privacy) and your desired result? So we can help you soon.

Janey

[AliceW]

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?

[AliceW]

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

[yaman123]

Hi,

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? 

[goncalogeraldes]

Hello there @yaman123 ! 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. 

Another way is to use the RELATED() function, like so:

New Column = RELATED('Budget Table'[Account Desc])

You can find further documentation here.

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

[yaman123]

Hi,

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? 

[goncalogeraldes]

@yaman123 That is because the RELATED() function only works from the many to the one side. Try using the LOOKUPVALUE() function then.

Further documentation here.

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