O'Reilly logo

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Marco Russo, Alberto Ferrari

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Using basic table functions

In this chapter, you will learn the difference between scalar functions and table functions in DAX. Table functions are very important for internal computations in DAX, and are useful when you write a DAX query instead of a DAX expression for a measure or a calculated column.

The goal here is to introduce the notion of table functions, but not to provide a detailed explanation of all the functions that you will see here for the first time. A deeper analysis of table functions is included in Chapter 9, “Advanced table functions.” Here, we will explain the role of table functions in DAX, and how to use them in common scenarios, including in scalar DAX expressions.

Introducing table functions

DAX is a functional ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required