This Day is for you if you have already studied Mastering DAX, whether in the classroom or on-demand with the video course. The contents of this Day have been delivered only a few times in pre-conference workshops at international conferences in the past, and they have been refreshed and updated for you.

Marco or Alberto will challenge you in your existing knowledge of DAX. Together, you will revisit the important foundations of key concepts such as row context, filter context, context transition, and functions like CALCULATE and KEEPFILTERS, which many advanced users do not actually fully understand. You will gather insights about data lineage, expanded tables, dependencies in calculated columns and tables, and different types of relationships, and this will likely shed some light on challenges you may be facing in your work with DAX.

The goal of this Day is to consolidate the more advanced concepts of DAX so you can figure out how to solve more complex calculations in DAX, or identify why an existing measure in your model does not work as expected. This Day is a good preparation for SQLBI Days - First Steps in DAX Optimization.