Status | Return a Table | Function | Description |
|---|---|---|---|
Not started | Yes | ALL | Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. |
Not started | Yes | ALLCROSSFILTERED | Clear all filters which are applied to a table. |
Not started | Yes | ALLEXCEPT | Removes all context filters in the table except filters that have been applied to the specified columns. |
Not started | Yes | ALLNOBLANKROW | 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, and disregards any context filters that might exist. |
Not started | Yes | ALLSELECTED | Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters. |
Not started | CALCULATE | Evaluates an expression in a modified filter context. | |
Not started | Yes | CALCULATETABLE | Evaluates a table expression in a modified filter context. |
Not started | EARLIER | Returns the current value of the specified column in an outer evaluation pass of the mentioned column. | |
Not started | EARLIEST | Returns the current value of the specified column in an outer evaluation pass of the specified column. | |
Done | Yes | FILTER | Returns a table that represents a subset of another table or expression. |
Not started | FIRST | Used in visual calculations only. Retrieves a value in the visual matrix from the first row of an axis. | |
Not started | INDEX | 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. | |
Not started | KEEPFILTERS | Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function. | |
Not started | LAST | Used in visual calculations only. Retrieves a value in the visual matrix from the last row of an axis. | |
Not started | LOOKUP | In visual calculation mode only. Look up the value when filters applied. | |
Not started | LOOKUPWITHTOTALS | In visual calculation mode only. Look up the value when filters applied. Filters not specified will not be inferred. | |
Not started | LOOKUPVALUE | Returns the value for the row that meets all criteria specified by search conditions. The function can apply one or more search conditions. | |
Not started | MATCHBY | In window functions, defines the columns that are used to determine how to match data and identify the current row. | |
Not started | MOVINGAVERAGE | Returns a moving average calculated along the given axis of the visual matrix. | |
Not started | NEXT | Used in visual calculations only. Retrieves a value in the next row of an axis in the visual matrix. | |
Not started | OFFSET | Returns a single row that is positioned either before or after the current row within the same table, by a given offset. | |
Not started | ORDERBY | Defines the columns that determine the sort order within each of a window function’s partitions. | |
Not started | PARTITIONBY | Defines the columns that are used to partition a window function’s | |
Not started | PREVIOUS | Used in visual calculations only. Retrieves a value in the previous row of an axis in the visual matrix. | |
Not started | Yes | RANGE | Returns an interval of rows within the given axis, relative to the current row. A shortcut for WINDOW. |
Not started | RANK | Returns the ranking of a row within the given interval. | |
Not started | Yes | REMOVEFILTERS | Clears filters from the specified tables or columns. |
Not started | ROWNUMBER | Returns the unique ranking of a row within the given interval. | |
Not started | RUNNINGSUM | Returns a running sum calculated along the given axis of the visual matrix. | |
Not started | Yes | SELECTEDVALUE | Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult. |
Not started | Yes | WINDOW | Returns multiple rows which are positioned within the given interval. |