22-25 April 2026 
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)