Select Page

Test if a value matches any value in a subsequent list of values. Returns True if the first value matches any of the subsequent values. Returns False if no values are matched.


In(<value>,<candidate 1>,…)

value (required) The value to test.

candidate 1 (required) The candidates to test value against. You must supply at least one candidate.

candidates 2+ (optional) You can supply additional candidates to test against.


In(“green”, “red”, “green”, “blue”)
  • Returns True.
In(“yellow”, “red”, “green”, “blue”)
  • Returns False.
In([Customer ID], 2000, 3000, 4000)
  • Returns True for rows where Customer ID is 2000, 3000, or 4000. Returns False for all other rows.
In([Customers], “Customer 1”, “Customer 2”)
  • Returns True for rows where [Customers] matches “Customer 1” or “Customer 2”. Returns false for all other rows.
In(“John Smith”, [Customers], [Buyers])
  • Returns True for rows where “John Smith” appears in either the Customers or the Buyers columns.

More About Logical Functions

Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.