Topic: DAX
Querying in DAX
DAX is not only an expression language but also a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless,… Watch now
DAX Query Engine Internals
The VertiPaq engine, which is the core of the new SQL Server Analysis Services Tabular engine, has an unprecedented level of performance, thanks to its fine-tuned architecture and its ability to perform fast cross-fltering. Automatic cross filtering between columns of… Watch now
Querying with DAX
The Data Analysis Expressions (DAX) language is commonly used to define measures and calculated columns in PowerPivot and in tabular models. However, you can also write queries in DAX, and in this 46-minute video Marco Russo explains what tools and… Watch now
DAX: The CALCULATE Function
CALCULATE is the single most important function in Data Analysis Expression (DAX) because it allows you to manipulate the filter context, which is necessary for building real-world calculations. Let Marco Russo explain it to you in this 47-minute video, which… Watch now
Querying and optimizing DAX
DAX Evaluation Context
Learning evaluation contexts in Data Analysis Expression (DAX) is fundamental to understanding the behaviour of this language, and to being able to write correctly functioning formulas for your desired calculations. Marco Russo teaches you these important concepts in this 50-minute… Watch now
Introduction to DAX
Introduce yourself to Data Analysis Expression (DAX) by learning the syntax and the fundamental functions of this language in this 40-minute video. Watch now
DAX: Calculated Columns vs. Measures
Learn the difference between calculated columns and measures in Data Analysis Expression (DAX) in this free, 10-minute video. Watch now
DAX in Action!
See the power of Data Analysis Expression (DAX) language in PowerPivot, and in SQL Server Data Tools (SSDT), in this free, 20-minute video. Watch now