Creating our first DAX script using “evaluate”

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”

.Evaulate

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

evaluate 'Product Subcategory'

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s