Video unavailable

SQLBits 2022

Expanded tables in DAX

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.

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.

Speaker

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.

Alberto Ferrari's Sessions

Time Intelligence in Power BI

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

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

Expanded tables in DAX

Introducing composite models in Power BI

Showing actuals and forecasts in the same chart with Power BI

Understanding composite models in Power BI

Using ALLEXCEPT or ALL/VALUES in DAX?

When you should avoid using bidirectional filters in Power BI

Why star schema is your best choice in Power BI

Can my Power BI report speak Italian?

Using calculation groups in DAX

Using calculation groups in DAX

Should you use bidirectional filters in Tabular?

Understanding relationships in Power BI

Aggregations in Power BI

DAX Optimization Examples

Optimizing multi-billion row tables in Tabular

Handling Relationships in DAX

Budgeting with Power Pivot

Optimizing & Analyzing DAX Query Plans

Advanced Modeling with Analysis Services Tabular

DAX Query Engine Internals

Inside xVelocity InMemory Engine (VertiPaq)

Time Intelligence in DAX

PowerPivot Advanced Data Modeling

Many-to-Many Relationships in DAX