In the previous section, we focused on those table functions that can be used to manipulate tables. Many of the other table functions fall into the date, time, and time intelligence functions, which we will look at in Chapter 8, Date, Time, and Time Intelligence Functions. The filter functions group also contains a number of table functions, and we'll cover those in Chapter 9, Filter Functions.
For the remainder of this chapter, we'll look at some functions that don't fall into these groups, and where table expressions can be used as parameters. Most of these functions fall into one of the following two categories:
- Functions that will iterate over the rows returned by the table expression given as a parameter, evaluating a DAX expression for each row of the table.
- Functions that will look for a specified value, in one or more columns...