Tag: CALCULATE

Evaluation Context In Power BI DAX

In this post, I expand more on the evaluation context in Power BI DAX. Evaluation context is also known as the initial context in Power BI. It is the environment from which your calculation is based on. To make things more advanced, can your formulas actually have multiple contexts working at the same time? Changing

Continue reading

Power BI Time Functions: DATEADD And More

In this article, I am going to talk about time intelligence functions in Power BI. We have already touched on a previous example with the fields Date, Total Sales, and Sales Last Year. As you can see, there is no data in Sales LY prior to 2019. In the DAX Formulas Reference Guide, you can

Continue reading

Power BI CALCULATE: Key To Advanced DAX Formulas

Now we are going to dive into the CALCULATE function in Power BI. We have already used the function many times but this is where I want to discuss it in detail. Getting The Sales Last Year With CALCULATE The CALCULATE function allows you to change the context of a calculation within a measure wherein

Continue reading

Introduction To Advanced DAX in Power BI

In this tutorial I want to show you some samples of Advanced DAX calculations in Power BI. After going through the basics, I’ll now demonstrate some advanced functions and formulas that are key to computing more complicated calculations. I won’t cover every formula or function, but instead I’ll give you an overview of a few

Continue reading

Advanced Product Budgeting – Actual Results To Budgets Per Product

I’m going to go over something specific in product budgeting. It’s quite advanced but if you can understand the concepts and the techniques that I go through here, you’ll also have a good understanding of what Power BI can do, how DAX works, and how you can combine a lot of different functions to get

Continue reading