Calculating rolling averages
Using the date or time variable directly may result in a time series with lots of variation. Smoothing can be done with rolling averages (ex. 7-day rolling average). In this exercise, you will compare a 7-day vs. 28-day rolling average to see which provides a smooth but informative trend.
If you have lost any progress, close any open reports and load 2_2_rolling_average.pbix
from the Workbooks folder on the Desktop.
This exercise is part of the course
Trend Analysis in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
