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.
I have a custom table to combine 6 source files. Each of the files have some information that other not have or actually do have. Here comes the Switch into place. For about 25 fields in the custom tables there is the Switch statement that refers to 6 VAR's containing minx expressions to grab the information from those 6 files.
To reduce the problem to the source of the issue, I left out the minx expressions and only had the VAR's and Switch statement (1st picture). Below you can find the result of my experiments. This can be quite easily reproduced by just stuffing the expression into a calculated column.
One of the solutions mentioned by others was to put the last VAR into the Switch statement as the last evaluated statement. But this doesn't seem to be always consistent (2nd picture). Most surprisingly is that a number substituted on the lone text value of one of the VAR's seem to solve the problem even when the data type of the column is Text (3rd picture).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.