Datatable is a DAX function, using this function you can create 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
Step-2: After click one DAX formula screen appears, write DAX formula here for static table and press enter key.
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.
Step-4: Final output of table.
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:
How to create Custom Theme in Power Bi
Enable Syncs Slicers in Power Bi
Gud one