PBI Calendar Overhaul: Calendar-Based Time Intelligence (with Jeroen [Jay] ter Heerdt)

LIVESTREAM DATE/TIME 📅

October 31st @ 9:30 AM (Pacific Time)

DESCRIPTION 📄

Product Manager Jeroen ter Heerdt demos Power BI’s new calendar-based time intelligence (Preview) — the long-overdue toolbox for anyone who’s ever cursed at week calculations, fiscal oddities, or retail 4-4-5 madness. He’ll show how to enable the preview and use the Calendar options UI or the TMDL model view to declare calendars so DAX finally behaves the way your business calendar actually does.

Expect live demos of week-aware DAX, examples mapping fiscal/retail/ISO calendars, tips on validating calendars (cardinality, partial vs complete categories), and notes on when this can improve performance versus classic time intelligence. This session is practical, so follow along with the preview enabled and bring your weird calendar.

GUEST BIO 👤

Dutch Data Dude. Product Manager at Microsoft.

Jeroen (Jay) ter Heerdt is a Product Manager at Microsoft. He works on Power BI and is passionate about "all things data"; his current focus is on DAX and modeling topics. He strives to be a “datanerd” in all aspects of his life. Jeroen combines enthusiasm, vision, and hands-on experience into his talks. He is on most social media as @jaypowerbi.

RELATED CONTENT 🔗

Calendar-based time intelligence
Introducing calendar-based time intelligence in DAX

Using Paired Columns in Power BI Field Parameters for Accurate Grouping

Video by: Reid Havens

Field parameters in Power BI offer powerful flexibility when using them for custom visual hierarchies. However, certain columns shouldn’t be used alone, especially when they’re part of a hierarchy or grouped relationship. In this video, I demonstrate how to create a field parameter setup that ensures key columns are always selected together. This approach avoids misleading rollups and duplicated values in matrix visuals, keeping your reports accurate and intuitive.

RELATED CONTENT 🔗

Field Parameters in Power BI

(Livestream Replay) Power BI Developer Mode: Connecting the Dots and Merging the Chaos! - Miguel Felix

DESCRIPTION 📄

Ever feel like Power BI is throwing you into a maze of connections and scattered reports? Fear not! In this fun and interactive session, we’ll dive into Power BI's Developer Mode to demystify the process of updating connections on your models and seamlessly merging two reports into one masterpiece. No more data juggling or report chaos—just a smooth path to Power BI harmony! Whether you're a data wrangler or a curious BI enthusiast, this session will have you laughing, learning, and connecting all the right dots.

GUEST BIO 👤

Miguel Félix is a Lead BI Architect, with a background in finance with experience in several different areas like banking, events, manufacturing, wholesale, services. Data analysis was always a part of his daily tasks and the change from Excel to Power BI was a step in the right direction allowing him to change to consulting in BI in 2021. The engagement with the community was also a natural and he is a Super User in the Fabric community since the start of the program back in 2018 that allowed him to achieve a Microsoft MVP for the first time in 2019, after that came the blog and the presentations about everything related with Power BI and Fabric.

RELATED CONTENT 🔗

Linkedin
Blog
Twitter
GitHub

IT'S HERE! Dark Mode for Power BI Desktop 📢

Video by: Reid Havens

Coming straight from the FabCon Europe announcement, we have Dark Mode for Power BI Desktop finally here! Join me, and a member of the Power BI team (Harleen Kaur). Tune in to learn more!

RELATED CONTENT 🔗

Link One
Link Two