Forum Discussion

jessicarocha's avatar
jessicarocha
Icon for Helper IV rankHelper IV
2 years ago

Create calculated column on a table based on columns from two different other tables

I would like to create a column in one table that is based in two other tables. The desired column (placed in the UNION table) should be able to say the amount of customer order schedule lines and pu...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

jessicarocha , You can use merge in Power Query or you can use Lookup, related, related table, Filter with joins. But in all cases tables from one table at a time and you can further do calculations

 

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

 

 

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo