Name | Syntax | Description | Status | Return | Output Type |
|---|---|---|---|---|---|
| Returns multiple rows which are positioned within the given interval | Table | |||
| Defines the columns that determine the sort order within WINDOW, OFFSET, INDEX and other functions | Table | |||
| Clear all filters which are applied to a table | Table | |||
| Returns the current value of the specified column in an outer evaluation pass of the mentioned column | Scalar | |||
| From the parent table of a relationship, returns all rows but the blank row, or all distinct values of a column but the blank row | Table | |||
| Returns a single row that is positioned either before or after the current row within the same table | Table | |||
| When the input parameter is a column name, returns a one-column table that contains the distinct values from the specified column | Table | |||
| Returns the current value of the specified column in an outer evaluation pass of the mentioned column | Scalar | |||
| Evaluates a table expression in a modified filter context | Table | |||
| Returns a table that represents a subset of another table or expression | Table | |||
| Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied | Table | |||
| In window functions, defines the columns that are used to determine how to match data and identify the current row. | Table | |||
| Returns the unique ranking of a row within the given interval. | Numeric | |||
| Used in visual calculations only. Retrieves a value in the visual matrix from the first row of an axis. | Scalar | |||
| Clears filters from the specified tables or columns. | Table | |||
| Used in visual calculations only. Retrieves a value in the previous row of an axis in the visual matrix. | Scalar | |||
| Defines the columns that are used to partition a window function's relation parameter. | Table | |||
| Returns a row at an absolute position, specified by the position parameter, within the specified partition, sorted by the specified order or on the specified axis. | Table | |||
| In visual calculation mode only. Look up the value when filters applied. | Scalar | |||
| Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters. | Table | |||
| Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult. | Scalar | |||
| Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function. | Table | |||
| Used in visual calculations only. Retrieves a value in the next row of an axis in the visual matrix. | Scalar | |||
| Returns a moving average calculated along the given axis of the visual matrix. | Scalar | |||
| Returns a running sum calculated along the given axis of the visual matrix. | Scalar | |||
| Removes all context filters in the table except filters that have been applied to the specified columns. | Table | |||
| Used in visual calculations only. Retrieves a value in the visual matrix from the last row of an axis. | Scalar | |||
| In visual calculation mode only. Look up the value when filters applied. Filters not specified will not be inferred. | Scalar | |||
| Returns the ranking of a row within the given interval. | Numeric | |||
| Returns the value for the row that meets all criteria specified by search conditions. The function can apply one or more search conditions. | Scalar | |||
| Returns an interval of rows within the given axis, relative to the current row. A shortcut for WINDOW. | Table | |||
| Evaluates an expression in a modified filter context | Scalar |