Calculate A Rolling Average In Power BI Using DAX
In this example, I'm going to show you how you can create a dynamic rolling average in Power BI.
This is a unique formula combination that allows you to calculate an average result for any selection or context that you have inside your Power BI reports.
We dive into the AVERAGEX function during this one, which is a very useful iterating function.
Enjoy.
Sam
**** Video Details ****
1:29 - understanding the formula logic
3:07 - DAX functions in the formula
4:58 - ALLSELECTED vs ALL function
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://www.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
**** Related Links ****
Running Totals In Power BI: How To Calculate Using DAX Formula - https://blog.enterprisedna.co/running...
DAX Calculations: Total Of Average Results - https://blog.enterprisedna.co/dax-cal...
Using Moving Averages To Show Trends In Power BI - https://blog.enterprisedna.co/showcas...
**** Related Course Modules ****
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...
Advanced DAX Combinations - http://portal.enterprisedna.co/p/adva...
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/uniq...
**** Related Support Forum Posts ****
Rolling Average Of A Measure - https://forum.enterprisedna.co/t/roll...
Rolling Quarter Average Without Filter - https://forum.enterprisedna.co/t/roll...
Moving Sales Average For 3 Months - https://forum.enterprisedna.co/t/movi...
For more rolling average support queries to review see here…. - https://forum.enterprisedna.co/search...
Watch video Calculate A Rolling Average In Power BI Using DAX online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 10 July 2019. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 67,080 times and liked it 387 visitors.
