Ultimate Power BI Rolling Averages Guide
When working with data it can be hard to see the trend when the period of time causes peaks and lows or compares how the last x days, weeks or months compare to the current day, week or month.
This is when rolling averages can help as it can smooth the data to a selected period of time, like the last 7 days or 4 weeks, to understand and compare periods and trends.
#PowerBI #DAX #PBICoreVisuals
📁 Dataset for Sales Data and file for original dim date table M code
https://data.world/deanchereden/super...
🔖c h a p t e r s 🔖
00:00 - Intro
00:34 - Load in data & date table
01:35 - Create total sales measure
02:10 - Rolling avg days - datesinperiod
06:40 - Rolling avg days - averagex
10:36 - Rolling avg days - window averagex
12:19 - Rolling avg days - window datesinperiod
13:50 - Rolling avg weeks - datesinperiod
15:58 - Rolling avg months - datesinperiod
18:54 - Dynamic rolling avg
22:34 - Dynamic conditional formatting
25:51 - Dynamic switching rolling avg
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Vhsceral - Gimetime https://chll.to/dd82e17f
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felicidade)...