Tag: Iterating Functions

Using Iterating Functions SUMX And AVERAGEX In Power BI

One of the most crucial topics for any Power BI beginner to know about is iterating functions. So before you dip your head in working with complex calculations, I will share with you some simple iterating functions in this article. Why Use Iterating Functions? I get this question all the time as I do live

Continue reading

Working With Iterating Functions In DAX

Iterating Formulas Deep Dive Power BI

I’ve seen some confusion with iterating functions in DAX whenever I work with Enterprise DNA members in the forum. So we will do a review of what can be achieved using these functions and why you should use them. As you get more into DAX formulas, you will use these iterating functions a lot more

Continue reading

Measure Averages Per Day Using AVERAGEX With DAX

Measure Averages Per Day Using AVERAGEX With DAX

Here I’m going to show you how to use the function AVERAGEX with DAX in Power BI. By learning and understanding how to use this function, you very quickly open up a range of analysis that can be incredibly insightful and valuable. Maybe you want to work out the average sales you make per day,

Continue reading

How To Understand Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

How To Understand Virtual Tables Inside Iterating Function In Power BI - DAX Concepts

I’m going to cover a very interesting topic around virtual tables, and how you can utilize them in Power BI within iterating functions. If you didn’t know it yet virtual tables are the essential ingredient to creating advanced logic inside of Power BI. A lot of the power of these virtual tables comes when you

Continue reading

Understanding How The AVERAGEX Function Works

Understanding How The AVERAGEX Function Works

In this example, we’ll dive deep into the AVERAGEX function. This is a truly powerful function that can be used in so many different ways. It can very efficiently calculate interesting results very quickly. You need to truly understand how this works and what’s happening behind the scenes. That’s what this tutorial is focussed on.

Continue reading