DATATABLE DAX Function (Table manipulation)

Returns a table with data defined inline.

Syntax

DATATABLE ( <name>, <type> [, <name>, <type> [, … ] ], <data> )

Parameter	Attributes	Description
name	Repeatable	A column name to be defined.
type	Repeatable	A type name to be associated with the column.
data		The data for the table.

Return values

Table An entire table or a table with one or more columns.

A table declaring an inline set of values.

Remarks

Unlike DATATABLE, Table Constructor allows any scalar expressions as input values.

The syntax used by DATATABLE is different from that used by Table Constructor.

Examples

Segments_Datatable = 
DATATABLE (
    "Price Range", STRING, 
    "Min Price", CURRENCY, 
    "Max Price", CURRENCY, 
    { 
        { "Low", 0, 10 }, 
        { "Medium", 10, 100 }, 
        { "High", 100, 9999999 } 
    } 
)

Learn more about DATATABLE in the following articles:

Create Static Tables in DAX Using the DATATABLE Function

You can create static tables in DAX using the DATATABLE function. This article describes the syntax of this new feature and shows when and how to use it. » Read more

Last update: Feb 6, 2019 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/datatable-function

Syntax

Return values

Remarks

Examples

Related articles

Contribute