In this tutorial, we’ll learn about evaluation context in DAX. Evaluation or initial context is the environment from which your dynamic calculation is based from. It’s important to understand how evaluation context works and how it affects your DAX calculation. So in the next section, I want to show you the different ways to create
One of the fundamental concepts that is important in building efficient reports is Power BI context. If you want to make effective analytical measures, it’s essential to learn how to manipulate the context of a certain measure. Context can help you perform dynamic analysis in Power BI. In addition to that, changing the context can
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
In this tutorial, I will cover the two places where you can write your DAX formulas. These two places are the calculated columns and measures. I will go over each one at a time and I’ll start with calculated columns. Using Calculated Columns A calculated column is an additional column that doesn’t exist in your
Power BI What-If parameters are a really powerful feature to implement in your models for scenario analysis. Scenario analysis is immensely important from an analytical perspective in Power BI and ‘What-If’ parameters allow you to quickly implement tables and measures for this type of analytics. Once you select the What-If parameter icon, it opens a
