Forum Discussion
SWITCH won't return a VAR table
Hi, I am trying to build up a virtual table using UNION and SELECTCOLUMNS, this table is variable and its content is based on another column, hence am using SWITCH so that I can build up the appr...
Hi Medmbchr ,
The switch function returns a single value of any type, not a table.
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply, that was my suspicion and your confirmed it.
Hence, how can I return a table in a VAR function using conditions? I tried combinations of IF() but it didn't work out either.
Regards,