Table manipulation

GROUPBY is a DAX function that creates a summary table grouped by specified columns. Syntax Argument Properties Description Table The input table. GroupBy_ColumnName Optional, Repeatable A … Read More

CURRENTGROUP is a DAX function that provides access to the subtable representing the current group in a GroupBy function and can only be used inside … Read More

VALUES is a DAX function that returns a single-column table of unique values from a specified column or a table with the same columns as the … Read More

UNION is a DAX function that returns the union of two or more tables with matching columns. Syntax Argument Properties Description Table Repeatable A table that … Read More

TREATAS is a DAX function that treats the columns of an input table as columns from other tables, filtering out values not present in the output … Read More

TOPN is a DAX function that returns the top N rows from a table based on a specified expression. Syntax Argument Properties Description N_Value The number … Read More

SUMMARIZE is a DAX function that creates a summary table grouped by specified columns from an input table. Syntax Argument Properties Description Table The input table. … Read More

SELECTCOLUMNS is a DAX function that returns a table with selected columns from an existing table and new columns defined by DAX expressions. Syntax Argument Properties … Read More

ROW is a DAX function that returns a single-row table with new columns defined by specified DAX expressions. Syntax Argument Properties Description Name Repeatable Name of … Read More

NATURALLEFTOUTERJOIN is a DAX function that joins two tables using left outer join semantics based on common columns. Syntax Argument Properties Description LeftTable The Left-side table … Read More