DATATABLE

DATATABLE is a DAX function that returns a table with data defined inline.

Syntax

DATATABLE(
   [ name, ... ],
   [ type, ... ],
   data
)

Argument	Properties	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

A table declaring an inline set of values.

Remarks

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

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

= DataTable("Name", STRING,
               "Region", STRING
               ,{
                        {" User1","East"},
                        {" User2","East"},
                        {" User3","West"},
                        {" User4","West"},
                        {" User4","East"}
                }
           )

Related functions

Other functions related to DATATABLE are:

• GENERATESERIES
• ROW

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/datatable-function-dax