In Chapter 6, Progressive DAX Syntax and Functions, we looked at the two types of functions found in the DAX language: scalar functions and table functions. We saw that table functions are functions that, when evaluated, return a table of data. Unlike scalar functions, which return a single value, table functions cannot directly be used to define a measure or a calculated column. Instead, they are used in conjunction with functions that accept a table expression as one of their parameters.
DAX table functions can be used for the following purposes:
- In a DAX expression that is used to define a calculated table (this excludes Excel Power Pivot, which currently does not support calculated tables).
- In the definition of a DAX function, where the function accepts a table expression as a parameter.
- To query a tabular data model using Excel or SQL Server Management...
