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.