Share via

SSMS DAX Query Editor

  • Article

We are excited to announce the SQL Server Management Studio DAX Query Editor! Have you ever authored a DAX query in SSMS using the MDX editor? With the new DAX Query Editor, you no longer need to do. Download RC3 for vNext from the SSMS release candidate download page.

ssms-dax-animated

To try it out, click on the new DAX Query toolbar button, or right-click > New Query in Object Explorer.

dax-query-toolbar-button

IntelliSense works for DAX functions and model objects. Members listed for selection are type aware. For example, after an EVALUATE statement, the DAX Query Editor expects a table type, so lists DAX table-valued functions, and tables in the model.

intellisense-functions

Once a function is selected, parameter information is provided.

parameter-info

In the following example, measures are offered for selection instead of DAX functions and tables based on the position of the parameter.

type-aware-parameter-info

And of course, syntax highlighting works too.

syntax-highlighting

We hope you agree these features make DAX query authoring in SSMS more productive. For example, the type-aware IntelliSense makes it easier to find what you’re looking for.

This is the first release of the SSMS DAX Query Editor; it is not yet in GA status. We are still adding enhancements. For example, DEFINE MEASURE syntax recognition, and parenthesis-match highlighting are planned for the next release. If you have suggestions for enhancements, or general feedback, please use ProBIToolsFeedback at microsoft.com.

Comments

  • Anonymous
    March 16, 2017
    Please consider supporting query parameters via a commented parameters xml block at the top of the query, similar to how DAX Studio works.This is highly useful for testing and debugging queries for reports.Here is an example:/* param1 Test Value */evaluate row("param1",@param1)
    • Anonymous
      March 16, 2017
      The text in the comment block above should have looked like an XML block with a Parameters tag containing a Parameter tag, which contains Name and Value tags for the parameter values.
      • Anonymous
        April 06, 2017
        Added to the backlog as a feature request. Does it have to be an XML block?
    • Anonymous
      April 06, 2017
      Thanks Dan. Yes, we will consider this and some other features.