<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

DAX for Data Modeling

Model smarter with DAX. Greg Trzeciak covers context, relationships, and table functions—RELATED, USERELATIONSHIP, CROSSFILTER, VALUES, SUMMARIZE, SELECTCOLUMNS, FILTER.

  • Course Info
  • Instructor
  • What to know beforehand
  • System Requirements

Course Description

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.

Course Outline ( Free Preview)

Module 01 - Introduction

Module 02 - Context

Module 03 - Relationships 2 min.

Module 04 - RELATED 8 min.

Module 05 - RELATEDTABLE 5 min.

Module 06 - USERELATIONSHIP 9 min.

Module 07 - CROSSFILTER 7 min.

Module 08 - VALUES + DISTINCT 11 min.

Module 09 - SUMMARIZE 7 min.

Module 10 - SELECTCOLUMNS 3 min.

Module 11 - Performance 3 min.

Module 12 - Class Wrap Up 2 min.

This course includes:

  • 1+ hours of training
  • 12 Modules
  • Intermediate level content
  • Access on mobile and browser
  • Certificate of Completion