Ultimate Power BI Rolling Averages Guide
Автор: Dean Chereden
Загружено: 2024-08-01
Просмотров: 7125
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)...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
