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:

Leave a Reply

Your email address will not be published.

*

clear formPost comment