Visualizing and comparing data that shows trends over time is one of the essential things you must get right when solving certain business questions. Especially when you deal with forecasts or seasonal analysis. 🤯
But when it comes to working with time periods in Power BI, you can’t do it without knowing your way around DAX functions and Power Query.
To eliminate any seasonality or fluctuations, it’s imperative to show your performance compared to a rolling or a moving average. What about visualizing your sales performance for the current month that refreshes automatically?
💥 Watch this webinar to learn how to implement it immediately!
00:00:00 - Intro
00:05:34 - Agenda
00:09:41 - Model & calendar dimension setup
00:12:32 - Period calculations (MTD, YTD, Full year)
00:23:09 - Handling YTD periods in measures
00:41:55 - Rolling periods as a dynamic axis in charts
00:44:16 - Fiscal calendar setup
00:51:50 - Adjusting YTD measures for fiscal periods
00:56:27 - Recap
00:58:35 - Q&A
01:24:10 - Outro
NOTE: Use of a Date column in a date/time format, e.g. 12/13/2020, for the Calendar dimension relationship, is the better choice in a tabular model, compared to DateID (date key) in integer format, e.g. 20201231. More about this: [ Ссылка ]
[ Ссылка ]
To try the examples yourself:
1. Download and install our complimentary free trial of Zebra BI visuals for Power BI
2. Unzip the file with examples and open them in Power BI
=========================================================
Download Zebra BI visuals for Power BI free: [ Ссылка ]
=========================================================
👋 With Zebra BI you can transform your Power BI reports into professional, interactive visualizations that tell a story. And the best part? You don't need advanced BI skills to get started.
👉👉👉 Try Zebra BI for Power BI for free today and see just how simple it is to create charts that get results: [ Ссылка ] 👈👈👈
ABOUT OUR CHANNEL
Our channel is all about Actionable Reporting and has one goal: to enable everyone to create better reports. We cover Power BI, Excel, and PowerPoint reporting, business intelligence, business analytics, data storytelling, and related topics.
Check out our channel here:
[ Ссылка ]
Don’t forget to subscribe!
CHECK OUT OUR OTHER VIDEOS
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
We make these awesome data visualization tools, check them out here:
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
FIND US AT
[ Ссылка ]
GET IN TOUCH
Contact us on info@zebrabi.com
FOLLOW US ON SOCIAL
Get updates & reach out on our Social Media Profiles!
Twitter: [ Ссылка ]
Facebook: [ Ссылка ]
LinkedIn: [ Ссылка ]
