Tag: Cumulative Totals

Showing Cumulative Total Only Up To A Specific Date In Power BI

In this tutorial, I’m going to cover a specific technique around Cumulative Total and budgeting information that you might be showing in your reports in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is a very common question in the Enterprise DNA Support Forum. It’s

Continue reading

Calculate Days Of Zero Stock – Power BI Inventory Management Insights

Calculate Days Of Zero Stock - Inventory Management Insights wPower BI

I’m going to go over a unique piece of analysis here concerning Power BI Inventory Management. You may watch the full video of this tutorial at the bottom of this blog. This idea came from a query on the Enterprise DNA support forum. The member wanted to work out how many days there were when

Continue reading

Using ALLEXCEPT To Stop The Cumulative Total From Resetting

I’m going to go through an interesting scenario that you’ll probably land on when you’re trying to run a Cumulative Total inside of Power BI. You may watch the full video of this tutorial at the bottom of this blog. A member from the Enterprise DNA support forum posted this query. The member wanted to calculate

Continue reading

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

In this blog post, you’ll learn how to show data from specific time frames as filtered by a date slicer without affecting the overall Cumulative Totals. This is based on a query on the Enterprise DNA Members-Only Support Forum. For sure, you’ll find this quite useful when facing a scenario similar to the example that

Continue reading

Dynamically Calculate A Power BI Running Total Or Cumulative Total

The Power BI running total is the perfect way to display patterns and changes on a specified data over time. In Power BI, there is a common combination of DAX functions that allow us to create a dynamic cumulative total on any report page. The DAX formula that we’re about to discuss is easy to

Continue reading