Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

calculated column with values from related table

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

 

Need Help

1 Reply

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    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