Forum Discussion
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...
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.
This is a very expensive transform. Don't do it. Let the data model of the semantic model consuming the dataflow do that work. Keep your dataflows to simple straightline spool type transforms.