Forum Discussion

padinator's avatar
padinator
Helper I
4 years ago
Solved

Create sum of Expanded Table Column (number) after NestedJoin

Hello there!   I have the following problem. I am Joining two tables in the classical way by "OrderNo". As i am joining these tables (LeftOuterJoin) i get several matching records in the second ta...
Need Help
Show and Tell
Tips and Tricks
  • Thingsclump's avatar
    Thingsclump
    4 years ago

    Hi padinator 

     

    Below screenshot shows a solution. You actually don't have to expand also after join.

     

    Table 2 column is created after merge which is shown in preview at the bottom.

     

    Sales amount total column is created using list.sum.

     

     

     

    Thanks,

    thingsclump

    www.thingsclump.com 

padinator's avatar
padinator
Helper I
4 years ago

One Solution would be to simply group the Columns back and create a sum by

 

= Table.Group(#"Erweiterte NAV Wertposten1",{"Entry No_", "Spedition", "Promised Delivery Date", "Customer No_", "Country", "ZIP Code", "Delivery Address", "Item Weight", "STP Spedition", "Item No_", "Quantity", "Cost", "Cost Type", "Order No_", "Pallets", "Packages", "Package Weight", "Lagerkosten", "Inventory Period", "KT Code", "KT Dim Code", "KT Name", "Marke Code", "Marke Dim Code", "Marke Name", "KTID", "MarkeID"},{"total", each List.Sum([Umsatz])})

 

Anyway, i am wondering if there is a more efficient way to do this since this takes a whole lot of time to calculate and i guess it is not very efficient.