We're very lucky this month to be visited by internationally renowned SSAS, DAX and Power BI expert, Marco Russo from SQLBI!
Marco has kindly offered up his time to educate you all on a topic that a lot of people struggle with when working with DAX: evaluation context. If you've ever had issues getting your measure calculation to reliably give you the correct answer when analysed using different fields in your data model then it's potentially been something to do with evaluation context.
Come and learn from the master!
DAX Filter Context in 1 hour
Understanding evaluation contexts is the key to understand DAX and to start thinking in DAX. In this session we will start from the basics of evaluation context and explain in detail the role of filter context and row context in DAX expressions, providing several examples of formulas where following the flow of contexts in the correct way is mandatory to make a sense out of the numbers computed.
At the end of the session you will have a clearer idea of the importance of evaluation context and you will probably look at your DAX code in a different way.
Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services.
A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services.
Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.
Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips.
When he is not working, you can find Marco fine-tuning his expertise of Neapolitan pizza or test driving electric cars.
• 11:45am - Registration and quick bite
• 11:55am - Welcome
• 12:00pm - Main presentation - DAX Filter Context in 1 hour
• 12:50pm - Q&A
• 1:00pm - Close
This session is not to be missed. Hope to see you there!