Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise