Tag: Running Totals

Calculate Rolling Totals in Power BI Using DAX

Here I’m going to show you how you can calculate the amount sold between two different dates. Another way to think about this is calculating rolling sales or running totals. We need the calculation to be dynamic, so that as we move through time we have a number that re-calculates based on the time frame

Continue reading

Running Totals Example In Power BI Using DAX Formula

Sometimes calculating running totals is a far better away to analyse trends than just looking at actual results on a daily basis. So that’s why I’m going to show you in this example how you can implement a running total calculation which is dynamic, which flows and integrates well into the rest of your model.

Continue reading