Skip to main content
Returns the result corresponding to the first matching value. If the case argument evaluates to True, then the corresponding result is returned, otherwise the else argument is returned. Category: logical Syntax: 
Switch(value, case1, result1, [case2], [result2], ..., [else])
Returns: AnyColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
valuecolumn|any✓ YesThe value to test.
case 1any✓ YesThe case to test the value against.
result 1any✓ YesThe result to be returned if its preceding case matches the input value.
additional cases and resultsvariadic✗ NoSeveral pairs can be listed in a single function. Every supplied case must have a corresponding result.
elseany✗ NoThe result to be returned if no cases match the value. If not supplied, a Null result is returned.

​
Validation

  • Minimum parameters: 3
  • Maximum parameters: Unlimited

​
Examples

Switch(1, 0, "None", 1, "One", "Many")
Tests value 1 against cases and returns corresponding result. Result: One 
Switch([dimension-param], "Product Family", [Product Family], "Product Type", [Product Type])
Dynamically returns different columns based on parameter selection.
Last modified on March 13, 2026