DAX for Data Modeling

Build models that answer better questions. In DAX for Data Modeling, Greg Trzeciak shows how DAX shapes the way your data behaves—through context, relationships, and carefully chosen table expressions. You’ll learn when to use calculated columns vs. measures, how filter and row context affect results, and where relationship settings (active/inactive, direction, cross-filtering) make or break your analysis. Then we’ll put DAX to work on real modeling tasks. You’ll connect tables with RELATED/RELATEDTABLE, activate the right path with USERELATIONSHIP, refine propagation with CROSSFILTER, and build tidy tables using VALUES, DISTINCT, SUMMARIZE, SELECTCOLUMNS, and FILTER. Along the way, Greg shares practical performance tips so your models stay fast, accurate, and easy to maintain.