Category: Business Intelligence

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

Attrition Analysis: Finding Lost Customers Using Power BI & DAX

In this tutorial, we’re going to focus on some customer attrition analysis in Power BI. Power BI is an amazing tool for high-quality analytics. In my view, it doesn’t have a close competitor at this point in time. The dashboard we’re using here is part of the Learning Summit I had on attrition analysis, but

Continue reading

Creating Virtual Relationships In Power BI Using The TREATAS Function

The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside your Power BI models. It has a very specific usage that can be beneficial if you are looking to simplify your data model and DAX formulas. In this tutorial, I’m going to show you how we can

Continue reading

Showing Month to Date (MTD) To Current Date In Power BI Using DAX

Showing month-to-date calculations to the current date (i.e. today) in Power BI is a common problem that I see all the time. The same goes with quarter- t- date and year-to-date. I’ve been asked this on the Enterprise DNA Support Forum quite a lot so it’s timely to create a tutorial around how to solve

Continue reading

Calculating Profit Leakage Using Power BI Analytics

In this blog post, I want to hone into a real world application of Power BI – How can we discover how much profit we are missing out on? There are probably a few ways that you can work out solutions to profit leakage. The way I have done it with this example is to

Continue reading