Other Functions

NATURALINNERJOIN

Performs an inner join of a table with another table. The tables are joined on …

UNION

Creates a union (join) table from a pair of tables.

TREATAS

Applies the result of a table expression as filters to columns from an unrelated table.

Table Constructor

Returns a table of one or more columns.

SUMMARIZECOLUMNS

Returns a summary table over a set of groups.

SELECTEDMEASURENAME

Used by expressions for calculation items to determine the measure that is in context by …

SELECTEDMEASUREFORMATSTRING

Used by expressions for calculation items to retrieve the format string of the measure that …

SELECTEDMEASURE

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

NATURALLEFTOUTERJOIN

Performs an inner join of a table with another table. The tables are joined on …

CONVERT

Converts an expression of one data type to another.

ISSELECTEDMEASURE

Used by expressions for calculation items to determine the measure that is in context is …

ISEMPTY

Checks if a table is empty.

INTERSECT

Returns the row intersection of two tables, retaining duplicates.

GROUPBY

The GROUPBY function is similar to the SUMMARIZE function. However, GROUPBY does not do an …

GENERATESERIES

Returns a single column table containing the values of an arithmetic series, that is, a …

EXCEPT

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

ERROR

Raises an error with an error message.

DATATABLE

Provides a mechanism for declaring an inline set of data values.