Tag: FILTER

Evaluation Context In Power BI DAX

In this post, I expand more on the evaluation context in Power BI DAX. You may watch the full video of this tutorial at the bottom of this blog. 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

Continue reading

How to Compare Current Sales to Previous Best Month in Power BI

In this tutorial, we’re going to learn more about the advanced time intelligence feature in Power BI to compare current sales to the previous best month. You may watch the full video of this tutorial at the bottom of this blog. This is actually a unique question that was raised at the Enterprise DNA Support

Continue reading

Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results using advanced DAX. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select?

Continue reading