List.AnyTrue

Updated on

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 logical

Description

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} )

Other functions related to List.AnyTrue are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/list-anytrue