Table manipulation

TOPNSKIP is a DAX function that returns the top N rows after skipping a specified number of rows based on a specified expression. Syntax Argument Properties … Read More

SUBSTITUTEWITHINDEX is a DAX function that returns a table representing the semijoin of two tables with common columns replaced by a 0-based index column. Syntax Argument … Read More

SUMMARIZECOLUMNS is a DAX function that creates a summary table with requested totals over a set of groups. Syntax Argument Properties Description GroupBy_ColumnName Optional, Repeatable A … Read More

SAMPLEAXISWITHLOCALMINMAX is a DAX function that returns a sample subset by binning the primary X-Axis into equal-sized bins and preserving local min/max for each bin across … Read More

SAMPLE is a DAX function that returns a subset of rows from a given table expression. Syntax Argument Properties Description Size Number of rows in the … Read More

ROLLUPISSUBTOTAL is a DAX function that pairs up rollup groups with columns added by ROLLUPADDISSUBTOTAL. Syntax Argument Properties Description GrandtotalFilter Optional Filter to be applied to … Read More

ROLLUP is a DAX function that identifies a subset of columns in the SUMMARIZE function to calculate subtotals. Syntax Argument Properties Description GroupBy_ColumnName Repeatable A column … Read More

ROLLUPADDISSUBTOTAL is a DAX function that identifies a subset of columns in the SUMMARIZECOLUMNS function to calculate groups of subtotals. Syntax Argument Properties Description GrandtotalFilter Optional … Read More

ROLLUPGROUP is a DAX function that identifies a subset of columns in the SUMMARIZE function to calculate groups of subtotals. Syntax Argument Properties Description GroupBy_ColumnName Repeatable … Read More

NONVISUAL is a DAX function that marks a filter as non-visual. Syntax Argument Properties Description Expression Filter expression. Return Values A table of values. Remarks Marks … Read More