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.
Solved! Go to Solution.
can you try. You need to pass on scalar value and not a column in SWITCH
SWITCH(TRUE(), MAX(tbl[SPI])....)
or
SWITCH(TRUE(), CALCULATE(MAX(tbl[SPI]))....)
IF there's only 1 case in the SWITCH, use an IF statement.
I think this will give you a clearer error message.
can you try. You need to pass on scalar value and not a column in SWITCH
SWITCH(TRUE(), MAX(tbl[SPI])....)
or
SWITCH(TRUE(), CALCULATE(MAX(tbl[SPI]))....)
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.