calculated column with values from related table

[Anonymous]

In Power Query Editor, I need to source a column from table "Sales order pricing line" to "Sales oreder line- data mart". How can I source it , based on the common column amongst the sheet.The tables in the report

The relationships between them

Query dependencies

[v-xicai]

Hi @Anonymous ,

>>I need to source a column from table "Sales order pricing line" to "Sales oreder line- data mart".

I am not sure what the words "source" is referred to. what calculated column and desired result would you want? Could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy