List.AnyTrue
Whether at least one item of a list of logical values is true.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.AnyTrue(list as list) as logical| Parameter | Type | Description |
|---|---|---|
list | list | A list of true and false values. |
Returns
logical. true when some item is true; an empty list gives false.
Remarks
- To test the items against a condition,
List.MatchesAnydoes it in one step.
Examples
Any order over the limit?
List.AnyTrue(List.Transform({450, 1200, 300}, each _ > 1000))trueNothing to check
List.AnyTrue({})false