Table Functions in DAX
Proposed session for SQLBits 2026TL; DR
In DAX, filters are tables. Therefore, being able to create tables means being able to generate filters that can be used in your measures to create interesting KPIs. In this session you will learn how to use the most important DAX table functions, along with practical examples.
Session Details
The DAX language is based on table manipulation. In fact, in DAX, iterators are a fundamental concept, and they scan tables, and filters are themselves tables. Therefore, only knowing very well table functions you can become a DAX expert, able to create any calculation your customer might need. In this session we shall go through the different table functions available in DAX and show how to use them in the best possible way, as tables to iterate or as filters in CALCULATE.
3 things you'll get out of this session
- Understand the differences between the several table functions in DAX
- Understand when to use which
- Apply these table functions into sophisticated calculations (measures)
Speakers
Francesco Bergamaschi's other proposed sessions for 2026
Calendar-based Time Intelligence in Power BI - 2026
Understanding CALCULATE, the queen of all DAX functions - 2026
Understanding DAX Pillars - 2026
User-Defined Functions (UDFs) in Power BI: overview and applications - 2026
Visual Calculation vs Measures in Power BI: which to choose, when and why - 2026
What NOT TO DO in DAX - 2026