Running sum
Source Result Part Number Qtr Qty Price Part Number Qtr Qty Price Running Sum ABC123 QTR 1 100 3ABC123 QTR 1 100 3 3ABC123 QTR 2 150 3ABC123 QTR 2 150 3 6ABC123 QTR 3 200 1ABC123 QTR 3 200 1 7ABC123 QTR 4 250 3ABC123 QTR 4 250 3 10ABC124 QTR 1 200 2ABC124 QTR 1 200 2 12ABC124 QTR 2 200 1ABC124 QTR 2 200 1 13ABC124 QTR 3 200 1ABC124 QTR 3 200 1 14ABC124 QTR 4 200 5ABC124 QTR 4 200 5 19ABC125 QTR 1 150 3ABC125 QTR 1 150 3 22ABC125 QTR 2 150 3ABC125 QTR 2 150 3 25ABC125 QTR 3 100 3ABC125 QTR 3 100 3 28ABC125 QTR 4 100 3ABC125 QTR 4 100 3 31
Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], TableType = Value.Type(Table.AddColumn(Source, "Running Sum", each null, type number)), Cumulative = List.Skip(List.Accumulate(Source[Price], {0}, (state, current) => state & {List.Last(state) + current})), RT = Table.FromColumns(Table.ToColumns(Source)&{Cumulative},TableType) in RT






Bookmarks