SQLBits 2023

DAX in 20 Minutes - The Hard Parts

One of the biggest hurdles in learning how to use Power BI is the DAX modeling language. While it looks simple, like Excel formulas, it requires a who set of mental models to use effectively. In this session, we'll cover all the roadblocks to getting started with DAX.
One of the biggest hurdles in learning how to use Power BI is the DAX modeling language. While it looks simple, like Excel formulas, it requires a who set of mental models to use effectively.

In this session, we'll cover all the roadblocks to getting started with DAX. Specifically, we'll talk about how the DAX engine is a columnar engine. We'll see how this affects compression and writing your measures. By the end of this session, you'll know what traps to look out for.