DATATABLE Provides a mechanism for declaring an inline set of data values.


DATATABLE (ColumnName1, DataType1, ColumnName2, DataType2..., {{Value1, Value2...}, {ValueN, ValueN+1...}...})


ColumnName – Any DAX expression that returns a table.

DataType – An enumeration that includes: INTEGER, DOUBLE, STRING, BOOLEAN, CURRENCY, DATETIME

Value – A single argument using Excel syntax for a one dimensional array constant, nested to provide an array of arrays. This argument represents the set of data values that will be in the table

Return Value

A table declaring an inline set of values.

Reference Data

DAX Functions / Other Functions / DATATABLE