HOW to make Calculated column from another table column with a many to many relationship b/w them.

[Anonymous]

Im trying to get the DO numbers for the related PO numbers from these two tables. Shows this error : The column 'DO Workflow[DO Number]' either doesn't exist or doesn't have a relationship to any table available in the current context.
Note:
 I have linked the po number columns of both table

[amitchandak · Accepted solution]

@Anonymous ,relatedtable or specific join (wath the video)

Sumx(relatedtable(Table1), table1[col])

Other copy value options : https://youtu.be/czNHt7UXIe8