Table constructor { } DAX Operator
A table constructor returns a table of one or more columns.
When there is only one column, the name of the column is Value.
When there are N columns where N > 1, the names of the columns from left to right are Value1, Value2, …, ValueN.
{ <scalarExpr1>, <scalarExpr2>, … } { ( <scalarExpr1>, <scalarExpr2>, … ), ( <scalarExpr1>, <scalarExpr2>, … ), … }
The first syntax returns a table of a single column.
The second syntax returns a table of one or more columns, where each row is enclosed between brackets.
The number of scalar expressions must be the same for all rows.
When the data types of the values for a column are different in different rows, all values are converted to a common data type.
Last update: Sep 16, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/table-constructor