Switch

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

Name	Type	Required	Description
`value`	`column\|any`	✓ Yes	The value to test.
`case 1`	`any`	✓ Yes	The case to test the value against.
`result 1`	`any`	✓ Yes	The result to be returned if its preceding case matches the input value.
`additional cases and results`	`variadic`	✗ No	Several pairs can be listed in a single function. Every supplied case must have a corresponding result.
`else`	`any`	✗ No	The 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

IsNull Zn

Aggregate Functions

Date Functions

Logical Functions

Math Functions

Text Functions

Type Functions

Window Functions

Parameters

Validation

Examples

​Parameters

​Validation

​Examples

Parameters

Validation

Examples