Forum Discussion
Merging multiple rows based on condition and aggregation
Hello Communtiy, I having an requirement from business users and need your help. From the screenshot, we have BatchNo column, for example the BatchNo HL18002040, business users want to merge Loa...
Hi, Anonymous ;
Sorry for the late reply, We could merge in powe query.
Add funtion.
= Table.Group(#"Changed Type", {"Batch"}, {{"Netweight", each List.Sum([NetWeight]), type nullable number}, {"a", each Text.Combine( [Date]," "), type nullable date}})The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous ;
Sorry for the late reply, We could merge in powe query.
Add funtion.
= Table.Group(#"Changed Type", {"Batch"}, {{"Netweight", each List.Sum([NetWeight]), type nullable number}, {"a", each Text.Combine( [Date],"
"), type nullable date}})The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.