Скачать с ютуб Dynamic LAST & PREVIOUS 12 Months in a Chart and Table | Power BI в хорошем качестве

Dynamic LAST & PREVIOUS 12 Months in a Chart and Table | Power BI

One thing I’ve found, in my many years of creating reports in Excel and then Power BI, is when working with monthly reports for clients they were static, as of that month, looking back 12 months and the only way clients could see the previous month's last 12 months was to look at an old report. This is what led me to find a way to change that by creating moving last 12 months based on the month and year selected and in this video, I show you how. #powerbi #dax #powerquery 📁 Dataset for Sales Data and file for original dim date table M code https://data.world/deanchereden/super... ▶️ Link to Rick’s original video I learnt the DAX from for last 13 months    • Show last 13 Months from Slicer Selec...   ▶️ Video clips used in intro https://mixkit.co/free-stock-video/bu... https://www.vecteezy.com/video/179390... 🔖c h a p t e r s 🔖 00:00 - Intro 00:36 - Overview of how it works 02:28 - Create a copy of your date table 02:28 - Create 'MonthYear' column 03:44 - Create 'MonthYear' sort column 04:14 - Set sort for 'MonthYear' column 05:25 - Create last 12 months dax measure 11:28 - Create previous last 12 months measure 12:54 - High and low conditional formatting 16:21 - Add measure to conditional format 17:32 - Create dynamic title measure 18:20 - Add dynamic title measure to title 💌 My email - [email protected] 🌍 My website - https://www.deanchereden.com 🐦 Twitter -   / deanchereden   🎵 Blue Wednesday - Middle School https://chll.to/877ea51a 🎶 Listen to Chillhop Music -    • Misha & Jussi Halme - Bliss (A Felici...