Archive

Used by expressions for calculation items to retrieve the format string of the measure that is in context.

Used by expressions for calculation items to reference the measure that is in context.

Performs an inner join of a table with another table. The tables are joined on common columns (by name) in the two tables. If the two tables have no common column names, an error is returned.

Performs an inner join of a table with another table. The tables are joined on common columns (by name) in the two tables. If the two tables have no common column names, an error is returned.

Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.

Checks if a table is empty.

Returns the row intersection of two tables, retaining duplicates.

The GROUPBY function is similar to the SUMMARIZE function. However, GROUPBY does not do an implicit CALCULATE for any extension columns that it adds. GROUPBY permits a new function, CURRENTGROUP(), to be used inside aggregation functions in the extension columns that it adds. GROUPBY attempts to reuse the data that has been grouped making it highly performant.

Returns a single column table containing the values of an arithmetic series, that is, a sequence of values in which each differs from the preceding by a constant quantity. The name of the column returned is Value.

Returns the rows of one table which do not appear in another table.