Table manipulation functions
These functions return a table or manipulate existing tables.
In this category
Function | Description |
---|---|
ADDCOLUMNS | Adds calculated columns to the given table or table expression. |
ADDMISSINGITEMS | Adds combinations of items from multiple columns to a table if they do not already exist. |
CROSSJOIN | Returns a table that contains the Cartesian product of all rows from all tables in the arguments. |
CURRENTGROUP | Returns a set of rows from the table argument of a GROUPBY expression. |
DATATABLE | Provides a mechanism for declaring an inline set of data values. |
DETAILROWS | Evaluates a Detail Rows Expression defined for a measure and returns the data. |
DISTINCT column | Returns a one-column table that contains the distinct values from the specified column. |
DISTINCT table | Returns a table by removing duplicate rows from another table or expression. |
EXCEPT | Returns the rows of one table which do not appear in another table. |
FILTERS | Returns a table of values directly applied as filters to columnName. |
GENERATE | 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 | 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 | Returns a single column table containing the values of an arithmetic series. |
GROUPBY | Similar to the SUMMARIZE function, GROUPBY does not do an implicit CALCULATE for any extension columns that it adds. |
IGNORE | Modifies SUMMARIZECOLUMNS by omitting specific expressions from the BLANK/NULL evaluation. |
INTERSECT | Returns the row intersection of two tables, retaining duplicates. |
NATURALINNERJOIN | Performs an inner join of a table with another table. |
NATURALLEFTOUTERJOIN | Performs a join of the LeftTable with the RightTable. |
ROLLUP | Modifies the behavior of SUMMARIZE by adding rollup rows to the result on columns defined by the groupBy_columnName parameter. |
ROLLUPADDISSUBTOTAL | Modifies the behavior of SUMMARIZECOLUMNS by adding rollup/subtotal rows to the result based on the groupBy_columnName columns. |
ROLLUPISSUBTOTAL | Pairs rollup groups with the column added by ROLLUPADDISSUBTOTAL within an ADDMISSINGITEMS expression. |
ROLLUPGROUP | Modifies the behavior of SUMMARIZE and SUMMARIZECOLUMNS by adding rollup rows to the result on columns defined by the the groupBy_columnName parameter. |
ROW | Returns a table with a single row containing values that result from the expressions given to each column. |
SELECTCOLUMNS | Adds calculated columns to the given table or table expression. |
SUBSTITUTEWITHINDEX | Returns a table which represents a left semijoin of the two tables supplied as arguments. |
SUMMARIZE | Returns a summary table for the requested totals over a set of groups. |
SUMMARIZECOLUMNS | Returns a summary table over a set of groups. |
Table Constructor | Returns a table of one or more columns. |
TOPN | Returns the top N rows of the specified table. |
TREATAS | Applies the result of a table expression as filters to columns from an unrelated table. |
UNION | Creates a union (join) table from a pair of tables. |
VALUES | Returns a one-column table that contains the distinct values from the specified table or column. |
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru