MATCHBY
Applies to: Calculated column Calculated table Measure Visual calculation
In window functions, defines the columns that are used to determine how to match data and identify the current row.
Syntax
MATCHBY ( [<matchBy_columnName>[, matchBy_columnName [, …]]] )
Parameters
Term | Definition |
---|---|
matchBy_columnName | (Optional) The name of an existing column to be used to identify current row in the window function’s <relation>. RELATED() may also be used to refer to a column in a table related to <relation>. |
Return value
This function does not return a value.
Remarks
This function can only be used within a window function expression.
Example
See OFFSET.
Related content
Understanding ORDERBY, PARTITIONBY, and MATCHBY functions
INDEX
OFFSET
ORDERBY
PARTITIONBY
WINDOW
RANK
ROWNUMBER