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.
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:
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |