Moving or rolling averages are used for smoothing out short-term fluctuations. They take into consideration the last data points over specific time period, averages them and then, rolls or "moves" this average forward in time, while the centered moving average, "centers" the average of a set of data points on the middle value of the data points and this helps reduce lag and provides a more accurate representation of underlying trends.
You can download the pbix file below. Feel free to poke it.
