Forum Discussion
PQRookie
1 year agoFrequent Visitor
Recursive running totals
Hi, I have a challenge where I have landed on that I have to conduct multiple running totals (RT) over a data set of some 1-2000 records (growing). The issues I have are: 1. The number of recur...
Omid_Motamedise
1 year agoSuper User
List.Generate is the best way to use for running total and you use it in the best way but do not use it as a custom function and use it directly as a part of your code, additionally instead of using List.Sum like List.Sum({[ RunningTotal ], AmountBuffer{[Counter]+1}}), use simple sum operation as
[ RunningTotal ]+ AmountBuffer{[Counter]+1}
to make it more efficient and if you whant to apply it over several columns do it at once by adding field value over List.Generate