List.AnyTrue
This function will return a value of true if any of the expressions within the provided list evaluate to true.
This function will return a value of true if any of the expressions within the provided list evaluate to true.
Example 1
Check if any of the statements in the list {true, false, 2 > 0} are true.
Usage:
Power Query MList.AnyTrue({true, false, 2 > 0})
Output:
true
Example 2
Check if any of the statements in the list {2 = 0, false, 2 < 0} are true.
Usage:
Power Query MList.AnyTrue({2 = 0, false, 2 < 0})
Output:
false