Table manipulation

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

INTERSECT is a DAX function that returns the rows that appear in both the left-side and right-side tables. Syntax Argument Properties Description LeftTable The Left-side table … Read More

GENERATESERIES is a DAX function that returns a table with a single column containing a sequential series of values from a start to an end value. … Read More

IGNORE is a DAX function that tags a measure expression to be ignored when determining non-blank rows in the SUMMARIZECOLUMNS function. Syntax Argument Properties Description Measure_Expression … Read More

FILTERS is a DAX function that returns the current filter values applied directly to a specified column. Syntax Argument Properties Description ColumnName The column for which … Read More

GENERATE is a DAX function that performs a cross join between two tables, evaluating the second table for each row of the first. Syntax Argument Properties … Read More

GENERATEALL is a DAX function that performs a cross join between two tables, including rows where the second table is empty. Syntax Argument Properties Description Table1 … Read More

EXCEPT is a DAX function that returns rows from the first table that do not appear in the second table. Syntax Argument Properties Description LeftTable The … Read More

DETAILROWS is a DAX function that returns the table data corresponding to the DetailRows expression defined on the specified Measure, or the entire table if no … Read More

DISTINCT is a DAX function that returns a one-column table with unique values from a specified column or a table with unique combinations of multiple columns. … Read More