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.
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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |