Скачать или смотреть DAX Guide - Rolling Average Measures Calculation

In this video, we show you how to create a rolling average measure in Power BI using DAX coding.

Go Analytics is a data analysis and visualization consulting firm specializing in Microsoft Power BI. For any Power BI inquiries, please contact us at https://goanalyticsbi.com/contact.

Registration for our Dashboard in a Day workshop: https://goanalyticsbi.com/dashboard-i...

You can download our template files here: https://goanalyticsbi.com/product/tem...

In this video, we explore the world of time-intelligence calculations in Power BI using DAX coding.

Through an example, we show you how to change the filter context in our DAX measure to create a 50-day and 200-day rolling average to analyze the trends in Microsoft's stock price over the past year. Follow along to learn about:

The importance of a robust Dates table for time-intelligence calculations, such as rolling averages, and how to create your own Dates table in Power Query using some M programming
Row and filter context nuances when modelling data in Power BI
The difference between AVERAGE and AVERAGEX functions in DAX
Using the DATESINPERIOD function in DAX to filter a dates table

Hope you enjoy this video and we'll see you in the next one!

For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.

About Go Analytics Inc.

We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.

Need help getting started with Power BI? Let's connect!
Visit our website at https://goanalyticsbi.com
Follow us on Twitter at   / goanalyticsinc  
Connect with us on LinkedIn at   / go-analytics-inc  

***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.