ISERROR
Checks whether a value is an error, and returns TRUE or FALSE.
Archive
ISBLANK
Checks whether a value is blank, and returns TRUE or FALSE.
CUSTOMDATA
Returns the content of the CustomData property in the connection string.
CONTAINS
Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false.
VALUES
When the input parameter is a column name, returns a one-column table that contains the distinct values from the specified column. Duplicate values are removed and only unique values are returned. A BLANK value can be added. When the input parameter is a table name, returns the rows from the specified table. Duplicate rows are preserved. A BLANK row can be added.
USERELATIONSHIP
Specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2.
SUBSTITUTEWITHINDEX
Returns a table which represents a left semijoin of the two tables supplied as arguments. The semijoin is performed by using common columns, determined by common column names and common data type . The columns being joined on are replaced with a single column in the returned table which is of type integer and contains an index. The index is a reference into the right join table given a specified sort order.
Columns in the right/second table supplied which do not exist in the left/first table supplied are not included in the returned table and are not used to join on.
The index starts at 0 (0-based) and is incremented by one for each additional row in the right/second join table supplied. The index is based on the sort order specified for the right/second join table.
SELECTEDVALUE
Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.
REMOVEFILTERS
Clear filters from the specified tables or columns.
RELATEDTABLE
Evaluates a table expression in a context modified by the given filters.