Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Needing help with a formula to calculate the Level of Support containing text of "high intensity" or "standard", with remaining categorized as "Other".
Service | Level of Support (calcaulate column) if contains: |
Support with High Intensity | High Intensity |
Standard Support | Standard |
Service Add 1 | Other |
Service Add 2 | Other |
Service Add 3 | Other |
With thanks,
Solved! Go to Solution.
@bbwong Maybe:
Column =
SWITCH(TRUE(),
SEARCH("High Intensity",[Service]),"High Intensity",
SEARCH("Standard",[Service]),"Standard",
"Other"
)
@bbwong Maybe:
Column =
SWITCH(TRUE(),
SEARCH("High Intensity",[Service]),"High Intensity",
SEARCH("Standard",[Service]),"Standard",
"Other"
)
Thanks for the prompt reply.
I tried the above however getting an error of:
Function 'SWITCH' does not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Column =
SWITCH(TRUE(),
SEARCH("High Intensity",[Service]) 1, 0 ) > 0,"High Intensity",
SEARCH("Standard",[Service]) 1, 0 ) > 0,"Standard",
"Other"
)