Forum Discussion

PeeWhy's avatar
PeeWhy
Frequent Visitor
4 years ago
Solved

Best Practice to Consolidate a Table with Multiple Values

I am having a hard time wrapping my head around the best way to merge this data and looking for a best practice approach.   Here is a sample of some raw data in an imported CSV.  There are some com...
Need Help
  • jsaunders_zero9's avatar
    jsaunders_zero9
    4 years ago

    Considering Grouping the rows in PowerQuery.

    = Table.Group(#"Changed Type", {"CUSTOMER", "CITY", "STATE"}, {{"INV", each List.Sum([INV]), type nullable number}, {"WEIGHT", each List.Sum([WEIGHT]), type nullable number}})

     

jsaunders_zero9's avatar
jsaunders_zero9
Responsive Resident
4 years ago

Considering Grouping the rows in PowerQuery.

= Table.Group(#"Changed Type", {"CUSTOMER", "CITY", "STATE"}, {{"INV", each List.Sum([INV]), type nullable number}, {"WEIGHT", each List.Sum([WEIGHT]), type nullable number}})

 

PeeWhy's avatar
PeeWhy
Frequent Visitor
4 years ago

I have never done that before.  Thank you!  Would you still do that if it were a much larger table to clean up?  

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi PeeWhy 

    if it were a much larger table, you can still use this way to clean up.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.