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.

Leave a Reply

Your email address will not be published.

*

clear formPost comment