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

5 Reasons to Hide Fields from Report View in Power BI

Let's discuss five reasons why you'd want to consider hiding columns from the report view in Power BI. All of these suggestions are centered around curating the Fields list during report development for both yourself, and any other potential business users or analysts who might want leverage your model for reports in the Power BI service. Tune in to learn more!

Video by: Reid Havens

Creating Date (Calendar) Hierarchy Columns in Power Query

Video by: Reid Havens

Part two of two of my videos on creating a Power Query Calendar Table. In this video we’ll see how to create the necessary date columns needed for dependent and independent hierarchies.

RELATED CONTENT 🔗

Part 1: Creating a Dynamic Range Calendar Table in Power Query

Implementing Different Date Table Hierarchy Types in Power BI

Video by: Reid Havens

Learn about two primary Hierarchy types you can implement on a Date Table in Power BI. I consider it a best practice to include dependent and independent date hierarchies, which can impact how users want to navigate the hierarchy controls in visuals.