Filter Help - Lookup with Condition

Those functions are there for the sole purpose: to be familiar for Excel/Sheets users. They are not optimized, i.e. they won’t short-circuit if earlier conditions are enough to determine the result.

See the similar thing explained here:

I.e.,

BigTable.Filter(
  Date >= Today()
  AND SomeComplicatedConditional1
  AND SomeComplicatedConditional2
  AND SomeComplicatedConditional3
)

would stop at checking the date if it’s in the past and never test the other three conditions — it’s already known that the result of the whole expression is false.

Whereas

BigTable.Filter(
  And(
    Date >= Today(),
    SomeComplicatedConditional1,
    SomeComplicatedConditional2,
    SomeComplicatedConditional3
  )
)

would calculate all four conditions every time because that’s how functions work — first the arguments are evaluated and then the function gets the results of each argument’s resulting value.

P.S. The official docs say it as well:

6 Likes