- Tables can be created using DAX function which is datatable().
- Returns a table with data defined inline.
- Datatable function allows values to be entered which is specific to the defined datatype only.
- Instead of using “Enter Data” option in Microsoft Power BI, this function can be used to restrict the garbage value in a column.
- Table can be viewed in Data View/ Table View in Power BI desktop.
- It can be used in creating DAX measures as well.
Table Creation using DATATABLE()
- Column names and their datatype need to be defined in the first section of the function.
- In the second part which is after opening the curly brackets, data must be entered in a way that it represents each row of the table.
Output:
Author By
Kamal Sharma
Kamal brings over 20 years of experience in data analytics and business intelligence. He has led the design and implementation of analytics solutions across operations, financial reporting, and performance improvement initiatives. With a background in business statistics and Six Sigma, his work focuses on applying data in a structured and practical way to solve real business challenges.
