The CumulativeSum function calculates the sum of the input column up to and including the current row value.



Function Arguments:

  • [Column] (required) - The column of numbers to evaluate the cumulative sum.

Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.


CumulativeSum(\[Monthly Revenue\])

A table contains the monthly revenue of a store for the year 2022. The CumulativeSumย function can be used to find the total yearly revenue up to and including that month.ย 

Related resources