Looking at DAX functions

The DAX language contains over 250 different functions. These functions are split into two different types, depending on the result returned. They can also be grouped depending on the functionality performed.

Function types

When evaluated, a DAX function will perform a specified action against the data in your data model and return a result. These functions fall into one of two categories depending on whether they return a single value or a table of data.

Those functions that return a single value are called scalar functions and form the majority of functions in the DAX language. They are typically used in expressions used for creating measures and calculated columns, which require a scalar value....