Alberto begins this video with a brief introduction to Time Intelligence, before showing you how to create a calendar table, which is needed for any time intelligence function to work. It can be created using Excel, or by loading it…  Watch now

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 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

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

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

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

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

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

Learn the difference between calculated columns and measures in Data Analysis Expression (DAX) in this free, 10-minute video.  Watch now