Watch the video above to learn how to create a Simple Moving Average (SMA) calculation in a Power BI measure. This calculation is handy especially while looking at stock price data, but you might want to add a moving average calculation to visuals with other types of data to smooth any wild fluctuations in the data.

Download PBIX

I hope you enjoyed learning this advanced trick! If you liked it, make sure to check out my Training courses here. All memberships grant you access to a live SQL Server database to practice Power BI!

Parker Stevens

Parker is the creator of the BI Elite YouTube channel, a community of over 30,000 students learning Power BI, DAX, and Power Query. He is a Microsoft Data Platform MVP for his work with Power BI and continues to provide elite Power Platform training courses to help data analysts, BI developers, and citizen dashboard creators reach their goals. Parker is committed to producing high-quality training content that is also extremely cost-effective, to ensure that the largest amount of users can benefit from the content. Training courses located at https://training.bielite.com/