Forum Discussion

Tan_LC's avatar
Tan_LC
Icon for Helper II rankHelper II
3 years ago

SUMIF using M Query

Hi, in below table, I would like to calculate Sum of Qty based on Date with additional column created. I've tried using below M Query but error pop up. Please refer Desired Outcome table for detail...
Need Help
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

Hi, Tan_LC 

    groups = Table.Group(before, {"Date"}, {{"rows", each _, type table [Date=nullable date, Factory=nullable text, Qty=nullable number]}, {"Sum of Qty", each List.Sum([Qty]), type nullable number}}),
    after = Table.ExpandTableColumn(groups, "rows", {"Factory", "Qty"}, {"Factory", "Qty"})