Press "Enter" to skip to content

Creating a Moving Average Time Series in Power BI

Naiden Borimechkov builds a moving average:

We begin by populating a custom dataset containing real historical time series data for the top 1000 stocks in the US stock market for the last 2 years. We need the closing prices as well as the percentage changes for each of the stocks.

After creating a basic line chart, Naiden incorporates some DAX to build up the rolling averages of results.