Table Functions in DAX

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.

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.

Speaker

Francesco Bergamaschi's Sessions

Calendar-based Time Intelligence in Power BI

Understanding CALCULATE, the queen of all DAX functions

User-Defined Functions (UDFs) in Power BI: overview and applications

Table Functions in DAX

Visual Calculation vs Measures in Power BI: which to choose, when and why

What NOT TO DO in DAX