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

Hi etane ,
Thanks for posting in Microsoft Fabric Community,
Since you prefer to avoid M code, you can achieve this using a calculated column using DAX instead of Power Query.

To calculate the total number of engines per transaction, follow these steps:

1. Confirm that there is a relationship between the Sales and Product Sales tables on the Transaction # field. [Product Sales----->Sales (Many to One)].

2. In the Sales Table, create a calculated column using the following DAX formula:

   EngineQty =
   VAR TransactionID = Sales[Transaction #]
   RETURN
   CALCULATE(
       SUM('Product Sales'[QTY]),
       'Product Sales'[Transaction #] = TransactionID,
       'Product Sales'[Part Type] = "Engine"
   )
   

    

3. This formula filters the Product Sales Table for rows matching the transaction number and where the Part Type is "Engine", then sums the QTY values.

    

4. After applying this calculated column, Sales Table will now display the total quantity of engines per transaction like below.

   

Hope this helps. Please reach out for further assistance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Best Regards,
Vinay.