Forum Discussion
How to use return for multiple values
Good morning everyone: I have 2 variables already calculated and I need to display them in 2 rows in the same table. How can I do it? I used RETURN but it only lets me show a singl...
Hi Anonymous
One calculated column can only show a single variable.
So if you want to show Number1 and Number2 in two columns, you can build two calculated columns or you can build a new table by addcolumns function.
New Table:
ADDCOLUMNS([Table],"Number1",...,"Number2",...)If you use Number1 &“ ”& Number2 like Fowmy's reply, your new value will return as value1 value2 (Separated by spaces) in one column.
And the type of your new column will return to text.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.