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
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

NewStep=let a=Table.Group(#"Changed Type","Date",{"n",each List.Sum([Qty])}) in Table.AddColumn(#"Changed Type","Sum of Qty",each a{[Date=[Date]]}[n])

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

AlienSx wdx223_Daniel , possible to attach me the solution in pbix. format coz I've tried inserting both of your formulas but still error.

 

Thank you.

Tan LC