MATCHBY DAX Function (Filter)

The columns used to determine how to match data and identify the current row. Can only be used within a Window function.

Syntax

MATCHBY ( [<MatchBy_ColumnName> [, <MatchBy_ColumnName> [, … ] ] ] )

Parameter	Attributes	Description
MatchBy_ColumnName	Optional Repeatable	A column used to determine how to identify the current row.

This function does not return a value.

Learn more about MATCHBY in the following articles:

Preparing a data model for Sankey Charts in Power BI
This article describes how to correctly shape a data model and prepare data to use a Sankey Chart as a funnel, considering events related to a customer (contact, trial, subscription, renewal, and others). » Read more
Understanding apply semantics for window functions in DAX
This article explains the unique behavior of apply semantics: a new way of computing table expressions when multiple rows are selected in DAX window functions. » Read more
Account receivable aging in Power BI
This article describes an Accounts Receivable Aging report in Power BI, and shows how to simplify a business problem using existing modeling patterns. » Read more

Contributors: Alberto Ferrari, Marco Russo