List.AnyTrue is a Power Query M function that checks if any expression in a list is true. The function returns true if at least one expression is true, otherwise false.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
List.AnyTrue( list as list ) as logicalDescription
Returns true if any expression in the list list is true.
Examples
Determine if any of the expressions in the list {true, false, 2 > 0} are true.
// Output: true
List.AnyTrue( {true, false, 2>0} )Determine if any of the expressions in the list {2 = 0, false, 2 < 0} are true.
// Output: false
List.AnyTrue( {2 = 0, false, 2 < 0} )Related functions
Other functions related to List.AnyTrue are:
