Tag: FILTER Function

Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique

In this tutorial, I’m going to teach you how to manage multiple date calculations in your Fact Table in Power BI. This is a frequent question in the Enterprise DNA Support Forum. These multiple dates could be order dates, ship dates, expiration dates, and arrival dates, among many others. This information might be located within

Continue reading

Using The MAXX DAX Function In Power BI To Calculate Recent Values In Your Data

This tutorial will talk about a common scenario that’s frequently asked in the Enterprise DNA support forum. You’re going to learn how to work out the most recent or the last value in your data using the MAXX and FILTER DAX functions in Power BI. For this example, there’s a list of data and within

Continue reading

Dynamically Calculating The Previous Highest Result Using DAX Functions

DAX functions greatly expand dynamic calculations. They also broaden the other important capabilities in Power BI.  In this tutorial, we’ll discuss how you can dynamically calculate the previous highest result in Power BI. We’ll also be learning the right combination of formula and techniques for this particular calculation. By doing a dynamic calculation, we can

Continue reading

Basket Analysis Introduction – Best Practice Tips For Power BI

Today, I’m going to introduce the amazing things that you can do with the basket analysis technique. With Basket Analysis inside Power BI, you can try to analyze the customer sales of one grouping of products versus another grouping of products. There’s plenty of application for this across Power BI. But for this tutorial, I

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