To create our first DAX script we can start with one of the easiest functions. In DAX you have a function that is called “evaluate”. This function is used to retrieve data from a specific table. No aggregation is performed.

To run this query you can start SQL Server Management Studio and then create a new MDX query (yes MDX. Even though you want to write DAX).

Paste the following query:

evaluate Product

This will give you a result with all the data in the Product table. It will give you the same result as a “select * from Product”

.

If you want query a table with spaces in the name you will have to add single quotes.

evaluate 'Product Subcategory'