cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## SLA Switch Statements Error - Text and number datatype not supported, use Value or Format

 Text Text Decimal Number Text Severity Calc Severity Time Spent Customer Reasons Severity 1 1 8.4 HW/SW Severity 2 2 2.3 Customer awaiting Severity 3 3 5.8 Severity 4 4 6.4 Severity 5 5 3.4 Severity 6 6 3.2

I want to write 9 - 10 If Else, so thinking to go with Switch. I get error text and number datatype not supported, use value or Format function for one of them

Example If Severity = 2 OR Severity = 3 && Time Spent > 10 , "flag"
If Severity = 3 && Time spent > 4 && Customer Reason!= "HW/SW","Flag","Good"

1 ACCEPTED SOLUTION
Super User

Since severity is a text column, you need to check it accordingly.

Try this as a calculated column:

SWITCH (
TRUE (),
Table1[Severity] IN { "2", "3" } && Table1[Time Spent] > 10, "flag",
Table1[Severity] = 3 && Table1[Time spent] > 4 && Table1[Customer Reason] <> "HW/SW", "Flag",
"Good"
)
Super User

Since severity is a text column, you need to check it accordingly.

Try this as a calculated column:

SWITCH (
TRUE (),
Table1[Severity] IN { "2", "3" } && Table1[Time Spent] > 10, "flag",
Table1[Severity] = 3 && Table1[Time spent] > 4 && Table1[Customer Reason] <> "HW/SW", "Flag",
"Good"
)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors