DATATABLE – create your data directly in Data Model with no connection (DAX – Power Pivot, Power BI)

This is about the DATATABLE function, which enables entering of a data directly in Power BI data model. 

It is somehow similar to manual data entering.

Using of DATATABLE is quite simple. Just create a new table and type the formula like this:

 

List of snakes = DATATABLE(

"Snake"; STRING; 

"Length cm"; double;

{ 

{"Anaconda";500}; 

{"Grass snake";120}; 

{"Viper";70}; 

{"Rattlesnake";140}; 

{"Coral";115} 

}

)

What does it mean? At the beginning there are names of columns with datatypes (use INTEGER, DOUBLE, STRING, BOOLEAN, CURRENCY or DATETIME).

Then there are rows of future table into curly brackets. Only constants are allowed – not calculations. But it doesn’t matter – since you use this table to calculate any column, measure or calculated table.