Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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"
)
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
83 | |
62 | |
61 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |