Tag: Running Totals

Fixing Incorrect Totals Using DAX Formula Techniques In Power BI

Fixing Incorrect Totals Using DAX Formula Techniques In Power BI

Getting totals correct inside your Power BI reports can sometimes be the most frustrating thing when utilizing DAX measures. The key to understanding how totals are calculated is to learn in-depth, how context works inside of Power BI. In this tutorial, I’ll go through several different examples of how to fix totals. By doing this,

Continue reading

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