Deceptive DAX
2022TL; DR
In this session several DAX expressions will be shown which do not always do what most Power BI users expect. Step by step these DAX expressions will be dissected and the evaluation context rules will be made clear such that you understand why the expressions behave different then expected.
Session Details
The DAX language is very powerful. Handy to compute the complex business values you need, but oh so frustrating if the DAX expression doesn't do what you expected it to do.
In this session several DAX expressions will be shown which do not always do what most Power BI users expect. Step by step these DAX expressions will be dissected and the evaluation context rules will be made clear such that you understand why the expressions behave different then expected.
This session aims at Power BI data model developers which have already a basic knowledge on writing DAX expressions and want to become more experienced in understanding the DAX evaluation context and extended tables.
3 things you'll get out of this session
Speakers
Nico Jacobs's other proposed sessions for 2026
Fabric Data Agents - 2026
It's about time: Calendar-based time intelligence in Power BI - 2026
The Power of Paginated Reports - 2026
What are Fabric Materialized Lake Views - 2026
When Translytical Task Flow meets Fabric Data Function - 2026
Nico Jacobs's previous sessions
Getting started with SparkML in Microsoft Fabric
Microsoft Fabric supports machine learning in their Spark notebooks. See an end-to-end demo of how Fabric data is used to build machine learning models upon, which are then used to make predictions about other Fabric datasets.
DAX in a Day
Learn in one day the core concepts of the DAX language, with a lot of focus on the evaluation context. (in-person only)
What Power BI users need to know about R
Learn the basic knowledge to use the R language in Power BI as source, transformation or visualization
Analyze data streams with Azure stream analytics
Azure stream analytics is a new Azure service for analyzing streaming data.