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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.