List.MatchesAll

Updated on

List.MatchesAll is a Power Query M function that checks if all values in a list satisfy a specified condition. The function returns true if all values meet the condition, and false otherwise.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

List.MatchesAll(
   list as list,
   condition as function,
) as logical

Description

Returns true if the condition function, condition, is satisfied by all values in the list list, otherwise returns false.

Examples

Determine if all the values in the list {11, 12, 13} are greater than 10.

// Output: true
List.MatchesAll( {11, 12, 13}, each _  > 10 )

Determine if all the values in the list {1, 2, 3} are greater than 10.

// Output: false
List.MatchesAll( {1, 2, 3}, each _  > 10 )

Learn more about List.MatchesAll in the following articles:

Other functions related to List.MatchesAll are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/list-matchesall