Power Query
Search…
List.MatchesAll

List.MatchesAll

Returns true if the condition function is satisfied by all values in the list.
function (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.

Category

List.Selection

Examples

Determine if all the values in the list {11, 12, 13} are greater than 10.
1
List.MatchesAll({11, 12, 13},each _ > 10)
Copied!
true
Determine if all the values in the list {1, 2, 3} are greater than 10.
1
List.MatchesAll({1, 2, 3},each _ > 10)
Copied!
false
Last modified 3yr ago