MATCHBY

MATCHBY is a DAX function that specifies the columns used to match data and identify the current row within a Window function.

Syntax

MATCHBY( [ MatchBy_ColumnName, ... ] )

Argument	Properties	Description
MatchBy_ColumnName	Optional, Repeatable	A column used to determine how to identify the current row.

Return Values

This function does not return a value.

Remarks

This function can only be used within a window function expression.

See OFFSET.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/matchby-function-dax