Expanded tables in DAX

2022

TL; DR

Expanded tables are an advanced theoretical DAX concept. Understanding them is important to fix performance and semantics issues of measures. In this session we introduce expanded tables and we show when it is important to consider them with some practical examples.

Session Details

Expanded tables are an advanced theoretical DAX concept. Understanding them is important to fix performance and semantics issues of measures. In this session we introduce expanded tables and we show when it is important to consider them with some practical examples.

3 things you'll get out of this session

Speaker

Alberto Ferrari's previous sessions

Time Intelligence in Power BI - 2023

Power BI User Group: Ask Me Anything! Learn from the Experts and Boost Your Skills - 2023

DAX side effects of the Sort By Column setting in Power BI - 2022

Expanded tables in DAX - 2022

Introducing composite models in Power BI - 2022

Showing actuals and forecasts in the same chart with Power BI - 2022

Understanding composite models in Power BI - 2022

Using ALLEXCEPT or ALL/VALUES in DAX? - 2022

When you should avoid using bidirectional filters in Power BI - 2022

Why star schema is your best choice in Power BI - 2022

Can my Power BI report speak Italian? - 2022

Using calculation groups in DAX - 2021

Using calculation groups in DAX - 2020

Should you use bidirectional filters in Tabular? - 2020

Understanding relationships in Power BI - 2019

Aggregations in Power BI - 2019

DAX Optimization Examples - 2018

Optimizing multi-billion row tables in Tabular - 2017

Handling Relationships in DAX - 2016

Budgeting with Power Pivot - 2015

Optimizing & Analyzing DAX Query Plans - 2014

Advanced Modeling with Analysis Services Tabular - 2014

DAX Query Engine Internals - 2013

Inside xVelocity InMemory Engine (VertiPaq) - 2013

Time Intelligence in DAX - 2012

PowerPivot Advanced Data Modeling - 2011

Many-to-Many Relationships in DAX - 2011