Select Page

Returns the value with the corresponding index position. When an index number is provided and a corresponding value does not exist, a Null result is returned.


Choose(<index Number>,<value 1>, <value 2>…)

index number (required) The index number of the value returned. Index value needs to be a number, a formula or column that references a number.

value 1 (required) The values from which to choose. At least one value must be provided.

value 2+ (optional) Additional values are optional.


Choose(1, “value 1”, “value 2”, “value 3”)
  • Returns value 1.
Choose(Weekday([Date]), “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”)
  • Returns the name of the day of the week falling on the date in the [Date] column.

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.