Chapter 9. Advanced table functions

In Chapter 3, “Using basic table functions,” when you were starting to learn DAX, we introduced the notion of table functions because they are extremely important in using and understanding iterators and filters. Now that your learning experience with DAX is increasing, it is time to cover the full, extremely rich set of DAX table functions.

Because there are many table functions, we grouped them in sets, according to their scope:

Image Filter functions

Image Projection functions

Grouping/Joining functions

Set functions ...

Get The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.