Help with Power Query (in PBi) - Groiup By

[Anonymous]

Hello Community  -  

Our ERP system occassionally does something odd, or perhaps it is a mistake from our supply chain team, but either way what happens is that it ends creating more shipped order lines than what the "orders" table says.     For example, if I were to print a report called "customer orders" from our ERP system, it shows that there were two lines shipped.  

But in that same report, if I go to the "shipping" module, we see that the supply chain team has created three separate shipping entries for Line 1  (rather than just one).  

The shipment dataflow that we use to capture this infomation (not built by me) captures all three of the lines below, but really I just need those three lines to be reduced to one, while showing the correct aggregated qtys of the three lines.  

How to solve, assuming Group By is the answer?

[Idrissshatila]

Hello @Anonymous ,

try to remove the duplicates, thus it will remove the added rows.

unless its the sum of these three rows is the right shipped quantity then you use group by.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin