Here I dive into the AVERAGEX function. 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, per month, per customer, per day, and so on. There are so many applications for this that it’s crazy. And don’t forget you can then branch out into time comparisons and time intelligence analysis.
In this example, in the video, I start right from the beginning, with something that can be easily applied in almost any model.
Having a very good understanding of the logic that AVERAGEX works through and also how iterating functions work is the key to this one. I can’t stress how important understanding iterating functions is, as they enable you to run through reasonably complex logic at a row level – not only on a physical table, but also a virtual table. By utilising the virtual table option, your analysis possibilities go through the roof.
Spend some time understanding the concepts in this video. It will assist immeasurably in your Power BI learning curve.