Other functions

These functions perform unique actions that cannot be defined by any of the categories.

In this category

Function Description
CONVERT Converts an expression of one data type to another.
DATATABLE Provides a mechanism for declaring an inline set of data values.
ERROR Raises an error with an error message.
EXCEPT Returns the rows of one table which do not appear in another table.
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.
INTERSECT Returns the row intersection of two tables, retaining duplicates.
ISEMPTY Checks if a table is empty.
ISSELECTEDSMEASURE Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.
NATURALINNERJOIN Performs an inner join of a table with another table.
NATURALLEFTOUTERJOIN Performs an inner join of a table with another table.
SELECTEDSMEASURE Used by expressions for calculation items to reference the measure that is in context.
SELECTEDSMEASUREFORMATSTRING Used by expressions for calculation items to retrieve the format string of the measure that is in context.
SELECTEDSMEASURENAME Used by expressions for calculation items to determine the measure that is in context by name.
SUMMARIZECOLUMNS Returns a summary table over a set of groups.
Table Constructor (DAX) Returns a table of one or more columns.
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.
VAR (DAX) Stores the result of an expression as a named variable, which can then be passed as an argument to other measure expressions.