Explore advanced techniques for handling many-to-many relationships in DAX with this comprehensive conference talk from PASS Data Community Summit. Dive deep into the Vertipaq engine and DAX programming language to understand how to leverage many-to-many relationships effectively. Learn about various scenarios where these relationships can be managed using DAX, including current accounts, survey data, and basket analysis. Discover the differences in implementation compared to SSAS, both in terms of data modeling and programming. Gain valuable insights into mastering many-to-many relationships, opening up new modeling scenarios with promising applications in SSAS. Follow along as the speaker demonstrates practical examples, explains DAX formulas, and discusses the intricacies of CALCULATE and query plans.
Overview
Syllabus
Who's Speaking?
Agenda
Prerequisites
Current Accounts Data Model M2M
The M2M DAX Pattern
The DAX Formula of M2M Pattern
What the formula should perform
How the formula works
The Karma of CALCULATE
Wrong formula in action CustomerName
Many-to-many in action
Cascading Alternative
Survey Data Model
Survey Scenario
Survey Analytical Data Model
Survey: The Final Result
Survey: The DAX Formula
Survey - Conclusions
Basket Analysis: The Scenario
Basket Analysis in SQL
Look the query plan...
Basket Analysis: The Data Model
Taught by
PASS Data Community Summit
Related Courses
-
Model data in Power BI
-
Data Modeling and Architecture
-
DAX Formulas for Running Total and % of Running Total & Other DAX Tricks
-
Excel Data Analysis - Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More
-
Hack Data Model, Date Table & DAX Measures Without Buying Power Pivot
-
Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
