Forum Discussion

etane's avatar
etane
Helper V
1 year ago
Solved

Power Query (Dataflow) Sum a Column from a Different Table

Hello.   Is there an easy way to sum a field that sits in a different table using Power Query (Dataflow)?  Below is an example.  I have a Sales Table that tracks transactions by customer.  And, I h...
Dataflow
Tips and Tricks
  • etane's avatar
    etane
    1 year ago

    Thank you for this.  However, I need to build the data in Dataflow because I have to append this table with another table for a combined sales history table

     

    At the moment, I am working with someone in our IT department to do the table building via SQL ands storing it in a local server for me to pull the data.

etane's avatar
etane
Helper V
1 year ago

Thank you for this.  However, I need to build the data in Dataflow because I have to append this table with another table for a combined sales history table

 

At the moment, I am working with someone in our IT department to do the table building via SQL ands storing it in a local server for me to pull the data.

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi etane ,

Thanks for getting back.

You can achieve this in Dataflow using a custom column. 

Since you mentioned working with your IT team to build the table using SQL and store it in a local server, this could be another viable approach.

Hope this helps you achieve your requirement! If you have any doubts or need further assistance, please feel free to reach out.

 

Please consider marking the helpful reply as Accepted solution to help others find it quickly.
Best Regards,
Vinay.