DAX in 20 Minutes - The Hard Parts

Explore the challenging aspects of DAX (Data Analysis Expressions) in this 19-minute conference talk from SQLBits. Dive into the mental models required for effective use of the DAX modeling language in Power BI. Learn about the common roadblocks beginners face, including false cognates, compression and encoding techniques, and the differences between Excel and DAX when adding months. Understand the concept of evaluation contexts and how they impact DAX formulas. Gain insights from speaker Eugene Meidinger as he breaks down the complexities of DAX, helping you overcome the steep learning curve associated with this powerful language for data modeling and analysis in Power BI.

Intro
THE DAX LEARNING CURVE
FALSE COGNATES
COMPRESSION AND ENCODING
EXCEL VERSUS DAX - ADDING MONTHS
EVALUATION CONTEXTS
SUMMARY