List.MatchesAll
This function returns a boolean value of true if all values in the list meet the conditions specified in the condition function. If any value does not satisfy the condition, the function will return f...
This function returns a boolean value of true if all values in the list meet the conditions specified in the condition function. If any value does not satisfy the condition, the function will return false.
Example 1
Check if all values in the set {11, 12, 13} are higher than 10.
Syntax:
Power Query MList.MatchesAll({11, 12, 13}, each _ > 10)
Result:
true
Example 2
Check if all values in the set {1, 2, 3} are greater than 10.
Syntax:
Power Query MList.MatchesAll({1, 2, 3}, each _ > 10)
Result:
false