Using AVERAGEX In Power BI – A DAX Tutorial & Examples

Using The AVERAGEX Function - DAX Tutorial & Examples

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

Continue reading

4 Techniques To Re-Use Moving Averages In Power BI

In this tutorial, I’m going to teach you how to highlight trends by using moving averages in Power BI in various ways. We can calculate one moving average and easily transfer the same formula into calculating other moving averages. All that’s required is changing one parameter inside the formula. This is a technique which I

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