UNION
The UNION function returns a table that is the result of concatenating the rows of two or more tables.
INTERSECT
The INTERSECT function returns the rows that result from the intersection of two tables, keeping duplicates.
GENERATESERIES
The GENERATESERIES function returns a table with a single column containing the values of an arithmetic progression.
EXCEPT
The EXCEPT function returns rows from one table that are not found in another table.
ERROR
The ERROR function displays an error message.
DATATABLE
The DATATABLE function allows you to declare a table by specifying its values.
SIGN
The SIGN function returns the sign of a number or the result of a calculation.
ISCROSSFILTERED
The ISCROSSFILTERED function returns the logical value True when the column indicated as an argument is being filtered directly or crossed by another column in the same table or in a related table.
ISFILTERED
The ISFILTERED function returns the logical value True when the indicated column is being filtered directly. If no filter is being applied directly or if the filter occurs because of another column in the same table or in a related table, the function returns the logical value False.
HASONEFILTER
The HASONEFILTER function returns the logical value True when the number of filters directly applied to the values of the indicated column is one, and returns False otherwise.
