Status | Function | Month | Description |
|---|---|---|---|
Not started | LOOKUPWITHTOTALS | June, 2025 | Used in visual calculations only. Look up the value when filters are applied. Filters not specified would not be inferred. |
Not started | LOOKUP | June, 2025 | Used in visual calculations only. Look up the value when filters are applied. |
Not started | FIRST | January, 2024 | Used in visual calculations only. Retrieves a value in the visual matrix from the first row of an axis. |
Not started | LAST | January, 2024 | Used in visual calculations only. Retrieves a value in the visual matrix from the last row of an axis. |
Not started | NEXT | January, 2024 | Used in visual calculations only. Retrieves a value in the next row of an axis in the visual matrix. |
Not started | PREVIOUS | January, 2024 | Used in visual calculations only. Retrieves a value in the previous row of an axis in the visual matrix. |
Not started | MATCHBY | May, 2023 | Define the columns that are used to to match data and identify the current row, in a window function expression. |
Not started | RANK | April, 2023 | Returns the ranking for the current context within the specified partition, sorted by the specified order. |
Not started | ROWNUMBER | April, 2023 | Returns the unique ranking for the current context within the specified partition, sorted by the specified order. |
Not started | LINEST | February, 2023 | Uses the Least Squares method to calculate a straight line that best fits the given data. |
Not started | LINESTX | February, 2023 | Uses the Least Squares method to calculate a straight line that best fits the given data. The data result from expressions evaluated for each row in a table. |