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
data.world/dea...
▶️ Link to Rick’s original video I learnt the DAX from for last 13 months
• Show last 13 Months fr...
▶️ Video clips used in intro
mixkit.co/free...
www.vecteezy.c...
🔖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 - dean@deanchereden.com
🌍 My website - www.deanchered...
🐦 Twitter - / deanchereden
🎵 Blue Wednesday - Middle School chll.to/877ea51a
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - ...
Негізгі бет Dynamic LAST & PREVIOUS 12 Months in a Chart and Table | Power BI
No video
Пікірлер: 20