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:
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'