Forum Discussion
Post PartisanAdd a new column with a value from another table
Super UserHello 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
Post PartisanHi,
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