Home » DAX » DAX – DATATABLE Function

DAX – DATATABLE Function

DataTable DAX function

Datatable is a DAX function. By using this function, you can create a static dataset/table in Power BI that cannot be refreshed, but you can modify it.

Syntax:

DATATABLE (column1, datatype1, 
coulmn2, datatype2, 
{
 {value1, value2},
 {value3, value4 } 
}
)

Description:

S no. Parameter Description
1 column A column name to be defined and it is repeatable
2 datatype Specify the column data type and it is repeatable
3 value The value for the table




Power BI Data Types as below:

  • BOOLEAN (True/False)
  • CURRENCY (Fixed Decimal Number)
  • DATETIME (Date/Time)
  • DOUBLE (Decimal Number)
  • INTEGER (Whole Number)
  • STRING (Text)

Let’s start with an example

Step-1: Go to Modeling tab and click on New table

Power Bi Modeling- New table

Power Bi Modeling- New table

Step-2: After click one DAX formula screen appears, write DAX formula here for static table and press enter key.

Table in Power Bi

Sales_Range_Datatable =

DATATABLE (

"Sales Range", STRING,

"Min Sales", INTEGER,

"Max Sales", INTEGER,

{

{ "Low", 0, 1000 },

{ "Medium", 1001, 10000 },

{ "High", 10001, 50000 }

}

)

Step-3: Table created successfully.

Table



Step-4: Final output of table.

DataTable DAX function

DataTable DAX function

How we can Modify or Add  DATATABLE records?

  • Double click on Datatable dataset name
  • Then DAX formula screen appears, change existing values or add new rows & columns
  • Then press enter key

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Recommended Power BI Post:

ALLSELECTED

ALL

ADDCOLUMNS

Power BI Performance Analyzer

How to create Custom Theme in Power Bi

Custom Tooltips in Power Bi

Enable Syncs Slicers in Power Bi

Power BI Interviews Q & A




1 thought on “DAX – DATATABLE Function”

Leave a Reply