Forum Discussion
Help with Power Query (in PBi) - Groiup By
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?
1 Reply
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 👍
