Category: Business Intelligence

Introduction to Filter Context in Power BI

Filter context is one of the major topics that any Power BI user should initially learn about, especially if you want your DAX calculations to work effectively. In this article, I will run through the filter context. Every DAX formula is calculated in a two-step process. DAX Formula: A Two-Step Process The first step is

Continue reading

Understanding Evaluation Context in Power BI

The most important concept in understanding DAX is context. There are three main types of context: the evaluation context, the filter context, and the row context. When DAX calculates something in Power BI, it works via a two-step process. At first, it evaluates the context it is currently in. Once it has done that, it

Continue reading

Group Customers Dynamically By Their Ranking w/RANKX In Power BI

As many of you know by now, I am huge on showcasing how you can apply Advanced DAX Formula to discover insights that historically have been difficult to find and also showcase easily. Well, this is another example of that and a great way to segment or group results rather than just showing results by

Continue reading

How To Organize Your Power BI Data Model – Best Practice Tips

BEST PRACTISE TIPS FOR MODEL ORGANIZATION

I wanted to highlight in this post some of my best practice tips for Power BI data modelling. In this tutorial, I go through many techniques in detail which I think you’ll find very beneficial as soon as you start implementing these into your reports. You’ll find that as you work through any development, certain

Continue reading

Using Power BI DAX Functions To Deal With Products That Have Changing Prices Overtime

DEALING W/ PRODUCTS WHERE PRICES CAN CHANGE

In this blog post, we are going to work through an advanced but real-world analysis involving Power BI DAX functions. The scenario in question is when you have products which change prices over time. A lot of the demos/showcases you have reviewed over time suggests that a product’s price stays exactly the same from the

Continue reading