Running total

The running total adds up a measure from the start of a series to the current row. In DAX, it is generally written with CALCULATE and a filter on dates less than or equal to the current date, or with window functions. It follows chronological order.

Example

Cumul = CALCULATE([CA], FILTER(ALL('Date'), 'Date'[Date] <= MAX('Date'[Date])))

Related concepts

The whole glossary