Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, im trying making a column using Switch function, got this error: "A table of multiple values was supplied where a single value was expected" and i don't know how to resolve it. Does anyone has any idea what can i do?
This is the function:
Solved! Go to Solution.
Hi, @uif19085
You can try the following methods.
Severity =
SWITCH(TRUE(),
NOT([SIL]) in {"QM","#TBD#"}, "ASIL",
[SIL]<>BLANK() && [Test_Severity] = "top","top",
[SIL]<>BLANK() && [Test_Severity] = "high","high",
[SIL]<>BLANK() && [Test_Severity] = "medium","medium",
[SIL]<>BLANK() && [Test_Severity] = "low","low",
[SIL]<>BLANK() && [Test_Severity]<>BLANK(),"Not Assigned")
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, it works, but had to replace every "<>" with "="
Hi, @uif19085
You can try the following methods.
Severity =
SWITCH(TRUE(),
NOT([SIL]) in {"QM","#TBD#"}, "ASIL",
[SIL]<>BLANK() && [Test_Severity] = "top","top",
[SIL]<>BLANK() && [Test_Severity] = "high","high",
[SIL]<>BLANK() && [Test_Severity] = "medium","medium",
[SIL]<>BLANK() && [Test_Severity] = "low","low",
[SIL]<>BLANK() && [Test_Severity]<>BLANK(),"Not Assigned")
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, it works, but had to replace every "<>" with "="
hi @uif19085
try like: