Database Reference
In-Depth Information
ORDER BY Customer[LastName],
Customer[FirstName]
, 'Product Category'[CategoryName]
The query returns only the sales figure for 2008, grouped by Customer and Cat-
egory .
See also
The DAX expression and the query language consists of about 180 functions with
more being added as the language evolves. You're not going to need to know how
to use all of these commands and functions, but having a good reference is helpful.
The DAX Function Reference pages on the TechNet site are a good place to begin.
These can be found at http://technet.microsoft.com/en-us/library/ee634396.aspx .
One of the coolest tricks I have learned about DAX was something Darren Gosbell ,
a SQL Server MVP from the UK, showed me not long ago. I was commenting that
not all of the latest DAX functions were included in Microsoft's online official docu-
mentation at the time. Darren showed me that when a new feature is added to the
language, the documentation actually gets added to the language metadata that you
can view by running a dynamic management view ( DMV ). Check this out; run the
following query in any MDX query window:
SELECT * FROM $System.MDSchema_Functions
This returns the complete online help and contextual metadata for both DAX and
MDX. If you want MDX only, use this expression in the WHERE clause: origin = 1 .
For DAX only, the WHERE expression would be WHERE origin = 3 OR origin =
4 (the DMV query syntax doesn't support extended SQL commands such as the IN
function). Putting it all together, we can use the following query to return complete
documentation for the DAX language:
SELECT
INTERFACE_NAME
, FUNCTION_NAME
, [DESCRIPTION]
Search WWH ::




Custom Search