Overview
Explore various methods for handling role playing dimensional behavior in tabular models used in Power BI, Power Pivot, and SQL Server Analysis Services. Dive into practical examples of implementing different alternatives, including the necessary DAX expressions for each approach. Examine the strengths and weaknesses of various techniques, focusing on best practices for model maintainability and user experience. Learn how to effectively manage common scenarios like linking order date, ship date, and invoice date to a single date table. Gain insights from this comprehensive conference talk recorded at PASS Summit 2019, presented by Brian Larson, to enhance your skills in designing and optimizing tabular data models.
Syllabus
Handling Role Playing Dimensions in Tabular Models - Brian Larson
Taught by
PASS Data Community Summit