Power Query
Search…
List.AllTrue

List.AllTrue

Returns true if all expressions are true.
function (list as list) as logical

Description

Returns true if all expressions in the list list are true.

Category

List.Membership functions

Examples

Determine if all the expressions in the list {true, true, 2 > 0} are true.
1
List.AllTrue({true, true, 2 > 0})
Copied!
true
Determine if all the expressions in the list {true, true, 2 < 0} are true.
1
List.AllTrue({true, false, 2 < 0})
Copied!
false
Last modified 3yr ago