Details

Speaker(s):  Marco Russo 

Duration: 120 minutes

Track: Analyze & Interpret

In this 2-hour session, Marco Russo will showcase the new features of DAX 2015 - the latest version of the DAX language available in Excel 2016, Power BI Desktop and Analysis Services 2016.
The latest version of DAX has many new functions to make writing complex calculations easier than before. The simpler ones are in statistical and financial area, but you will discover many new table functions that are useful to both report developers who write or generate DAX queries, and business analysts creating calculations that require temporary, intermediate tables for different calculation steps.
One of the most important new features is the introduction of variables. You can store values and tables in variables that can be used in more complex expressions. This powerful feature also eliminates the need for EARLIER and EARLIEST in all expressions, as you will see comparing the same code written with and without the variables.
During the session, you learn new functions and features of DAX through many practical examples and patterns and learn about common pitfalls to avoid, regardless of which DAX version you use. 
A basic knowledge of DAX syntax and some experience in its use is required to attend the session.