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 a table that contains the Cartesian product of rows from all the tables given as parameters.
- DATATABLE: Returns a table that has been defined and populated by the parameters passed into the function.
- DETAILROWS: Takes the measure passed in as a parameter and returns a table that is obtained by evaluating the Detail Rows Expression of that measure.
- DISTINCT: Returns a table that contains the distinct values ...
