Running totals simply (DAX – Power Pivot, Power BI)

How to calculate running totals in Power BI / Power Pivot?

For example here we can calculate cumulative revenue for entire week from beginning.

You need:

• Column for adding / sorting. In this example it is Index. This column doesn´t have to be sorted.
• Column to summarize – in this example Revenue.

Or you can have just one column for adding / sorting and for summarizing.

The formula is like this:

• Cummulative revenue – all week = SUMX(FILTER(Table1;Table1[Index]<=EARLIER([Index]));[Revenue])

To calculate running total in M, click here.