Calculating Averages Per Day, Month or Year Within Power BI

3 comments

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.

***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources

3 comments on “Calculating Averages Per Day, Month or Year Within Power BI”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s