Nearly every data model involves date-related data - yes, even the ones without any romantic complications. That’s why building a proper date table is one of the most important (and most overlooked) foundations of a solid Power BI model.

While Power BI Desktop automatically creates hidden date tables by default, relying on them can lead to performance issues, limited flexibility, and unexpected behavior. Even Microsoft recommends turning this feature off unless your time-related requirements are extremely simple - and let’s be honest, they rarely are.

In this session, Markus Ehrenmueller-Jensen will walk you through everything you need to know to create and maintain the perfect date table for your data model. You’ll explore the downsides of auto-generated tables, learn when and why to mark a table as a "date table," and discover best practices for handling multiple date fields in your model.

Even better: You'll walk away with ready-to-use scripts for building robust, customizable date tables in DAX, Power Query, and SQL - so you can choose the approach that best fits your workflow and environment - so it’ll be up-to-date (pun fully intended).

What You'll Learn:
* Why you should avoid Power BI’s auto-generated date tables
* How to build a reusable, high-performing date table
* When and how to mark a table as a date table
* How to support multiple date fields and filters in your model
* Practical scripts in DAX, Power Query, SQL, and PySpark to get you started

Who Should Attend:
Power BI users, data modelers, and BI professionals who want to improve their time intelligence and eliminate common date-related pitfalls.