Tag: Cumulative totals Power BI

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. This idea came from a query on the Enterprise DNA support forum. The member wanted to work out how many days there were when the inventory was at zero. This is going to be based on stock movement data.

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.  A member from the Enterprise DNA support forum posted this query. The member wanted to calculate a running balance like a Cumulative Total. The problem was every time a selection

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

Showcasing Budgets In Power BI – DAX Cumulative Totals

Recently, I built and showed a Budgeting Analysis Dashboard in one of Enterprise DNA’s workshop. One feature of that Dashboard is the Cumulative Budget view. The webinar is linked here. The dashboard itself is dynamic so I can change the time frame and select the products I want to track. This makes exploring the data

Continue reading

Calculating Reverse Cumulative or Reverse Running Total In Power BI

Calculating a cumulative total, also known as a running total, in Power BI, is definitely common to most businesses due to its indispensability in performing calculations to show the total of a measure up to a certain date. But did you know that creating a reverse cumulative total is as essential as calculating the cumulative

Continue reading