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
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
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
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
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
