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