List.MatchesAll Function in Power Query
The List.MatchesAll function returns true if all items in a list meets a condition, otherwise returns false.
Syntax
List.MatchesAll(list as list, condition as function) as logical
Example: We are going to check that whether all the number in the list are positive.
Power Query M
let source = {12456, 127895, 128690, 125478}, return = List.MatchesAll(source, each Number.Sign(_)= 1) in return
The output of the above code is true. As the all the numbers are positive.