DAX II – Extending the use of Evaluate


In a previous post, I looked at evaluate as the method to return a table in a row-set form. However, the query syntax allows us to more precisely define the result set and this is the focus of this post.

Books on line specifies three optional arguments that can be used in query syntax to control, there are DEFINE, ORDER BY and START AT. The syntax follows the format;

 

[DEFINE { MEASURE <tableName>[<name>] = <expression> }

One thought on “DAX II – Extending the use of Evaluate

  1. Pingback: Tabular Queries in Excel 2013, Good news, Bad news,DAX Queries and the missing DAX visual query builder « Rui Quintino Blog

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s