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.