AVERAGEX in Power BI is an incredibly versatile function. It’s not just for averaging values; it’s also great for trend analysis. I discussed the use of AVERAGEX for trend analysis in the Enterprise DNA Learning Summit. A link to the event can be found below. But in this post, I’m going to focus more on
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
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
