Looking at table manipulation functions

In Chapter 6, Progressive DAX Syntax and Functions, we looked at the different groups of functions that are available in the DAX language. As we saw, individual DAX functions can be grouped depending on the functionality they provide. However, functions from across these groups can also belong to another type of group: table manipulation functions.

Table manipulation functions reference

The following is a list of the DAX functions that can be used to manipulate tables in your data model, returning the result as another table:

• ADDCOLUMNS: Takes the specified table and returns a table with additional columns, as defined by a given DAX expression and with a given name.
• CROSSJOIN: Returns...