Ultimate Power BI Rolling Averages Guide скачать в хорошем качестве

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 - dean@deanchereden.com 🌍 My website - https://www.deanchereden.com 🐦 Twitter -   / deanchereden   🎵 Vhsceral - Gimetime https://chll.to/dd82e17f 🎶 Listen to Chillhop Music -    • Misha & Jussi Halme - Bliss (A Felicidade)...