Table manipulation

DATATABLE is a DAX function that returns a table with data defined inline. Syntax Argument Properties Description name Repeatable A column name to be defined. … Read More

CROSSJOIN is a DAX function that returns a table that is a crossjoin of the specified tables. Syntax Argument Properties Description Table Repeatable A table … Read More

ADDMISSINGITEMS is a DAX function that adds rows with empty measure values back into a table. Syntax Argument Properties Description ShowAll_ColumnName Optional, Repeatable ShowAll columns. … Read More

ADDCOLUMNS is a DAX function that returns a table with new columns specified by DAX expressions. Syntax Argument Properties Description Table The table to which … Read More