Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |