Function | Status | Description |
|---|---|---|
ADDCOLUMNS | Not started | Adds calculated columns to the given table or table expression. |
ADDMISSINGITEMS | Not started | Adds combinations of items from multiple columns to a table if they do not already exist. |
CROSSJOIN | Not started | Returns a table that contains the Cartesian product of all rows from all tables in the arguments. |
CURRENTGROUP | Not started | Returns a set of rows from the table argument of a GROUPBY expression. |
DATATABLE | Not started | Provides a mechanism for declaring an inline set of data values. |
DETAILROWS | Not started | Evaluates a Detail Rows Expression defined for a measure and returns the data. |
DISTINCT column | Not started | Returns a one-column table that contains the distinct values from the specified column. |
DISTINCT table | Not started | Returns a table by removing duplicate rows from another table or expression. |
EXCEPT | Not started | Returns the rows of one table which do not appear in another table. |
FILTERS | Not started | Returns a table of values directly applied as filters to |
GENERATE | Not started | Returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1. |
GENERATEALL | Not started | Returns a table with the Cartesian product between each row in table1 and the table that results from evaluating table2 in the context of the current row from table1. |
GENERATESERIES | Not started | Returns a single column table containing the values of an arithmetic series. |
GROUPBY | Not started | Similar to the SUMMARIZE function, GROUPBY does not do an implicit CALCULATE for any extension columns that it adds. |
IGNORE | Not started | Modifies SUMMARIZECOLUMNS by omitting specific expressions from the BLANK/NULL evaluation. |
INTERSECT | Not started | Returns the row intersection of two tables, retaining duplicates. |
NATURALINNERJOIN | Not started | Performs an inner join of a table with another table. |
NATURALLEFTOUTERJOIN | Not started | Performs a join of the LeftTable with the RightTable. |
ROLLUP | Not started | Modifies the behavior of SUMMARIZE by adding rollup rows to the result on columns defined by the groupBy_columnName parameter. |
ROLLUPADDISSUBTOTAL | Not started | Modifies the behavior of SUMMARIZECOLUMNS by adding rollup/subtotal rows to the result based on the groupBy_columnName columns. |
ROLLUPISSUBTOTAL | Not started | Pairs rollup groups with the column added by ROLLUPADDISSUBTOTAL within an ADDMISSINGITEMS expression. |
ROLLUPGROUP | Not started | Modifies the behavior of SUMMARIZE and SUMMARIZECOLUMNS by adding rollup rows to the result on columns defined by the the groupBy_columnName parameter. |
ROW | Not started | Returns a table with a single row containing values that result from the expressions given to each column. |
SELECTCOLUMNS | Not started | Adds calculated columns to the given table or table expression. |
SUBSTITUTEWITHINDEX | Not started | Returns a table which represents a left semijoin of the two tables supplied as arguments. |
SUMMARIZE | Not started | Returns a summary table for the requested totals over a set of groups. |
SUMMARIZECOLUMNS | Not started | Returns a summary table over a set of groups. |
Table Constructor | Not started | Returns a table of one or more columns. |
TOPN | Not started | Returns the top N rows of the specified table. |
TREATAS | Not started | Applies the result of a table expression as filters to columns from an unrelated table. |
UNION | Not started | Creates a union (join) table from a pair of tables. |
VALUES | Not started | Returns a one-column table that contains the distinct values from the specified table or column. |