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...
Смотрите видео Calculate A Rolling Average In Power BI Using DAX онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Enterprise DNA 10 Июль 2019. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 67,080 раз и оно понравилось 387 посетителям.
