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.
- 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: