Tag: Cumulative Totals

DAX Examples In Power BI – Advanced DAX Formulas

In this tutorial, I’ll show you some advanced formulas and DAX examples using different functions in Power BI. Some of the functions that you’ll encounter in the examples below are CALCULATE, FILTER, MAX, ALLSELECTED, and many more. But before you begin, make sure to optimize your measures. I always recommend using measure groups to make

Continue reading

Creating A Pareto Chart In Power BI – Advanced DAX

Creating A Pareto Chart In Power BI - Advanced DAX

This blog tutorial showcases a really interesting example around Pareto analysis. I’m going to teach you how to create a Pareto chart using advanced DAX formulas. I’ll show you how to use a combination of formulas to be able to generate a visualization like this one. The first thing that I always recommend when working

Continue reading

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. This is a very common question in the Enterprise DNA Support Forum. It’s usually asked when people are trying to do a comparison between their Cumulative Totals and

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