Tag: DAX Functions

Iterating Functions In DAX Language – A Detailed Example

For this blog post, I want to dive into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just

Continue reading

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

Extracting Unique Insights In Power BI Using Ranking DAX Measures

In this blog, I showcase ranking DAX measures to analyse something really practical and get amazing insights inside Power BI. It’s to work out the total sales of my top 3 salespeople based in any region. A really interesting insight, right? It might seem relatively intuitive, but actually implementing this inside of Power BI is

Continue reading

Discover Unique Insights Using Power BI TOPN Function

In this video, I wanted to find an insight that was really unique, and hugely valuable for business. Here, I used the Power BI TOPN function. I wanted to know the best-selling day for every single product. Not only that, I wanted to be able to look dynamically into any store and analyse the best-selling

Continue reading