Reduce a List with List.Accumulate in Power Query M

Folds a list down into a single value by applying a function across every item, similar to reduce() in other languages.

Advanced M FunctionsAdvancedlist.accumulatereducefold

Power Query M code

let
    Numbers = {1, 2, 3, 4, 5},
    Total = List.Accumulate(Numbers, 0, (state, current) => state + current)
in
    Total

Notes

The second argument is the starting value (the seed); the function receives the running total (state) and each item (current) in turn.

Requirements

A list of values to reduce to one result.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Reduce a List with List.Accumulate.