BT

New DAX Editor Simplifies PowerPivot Formula Creation

by Jenni Konrad on Nov 23, 2011 |

The SQL Server Analysis Services Team recently announced the release of their DAX Editor for SQL Server as a Visual Studio 2010 extension. Until this point, there hasn't been an editor for DAX queries that supports syntax highlighting, IntelliSense, and other basic Visual Studio Features.

Data Analysis Expressions, known as DAX, is a language used to construct formulas in PowerPivot tables and Excel PivotTables. DAX syntax is similar to that of Excel formulas, and it can be used to create calculated columns and measures in PowerPivot. The PowerPivot Window (like Excel) uses a formula bar for manual entry of DAX formulas.

The DAX Editor for SQL Server adds familiar Visual Studio editing features, such as auto-formatting, IntelliSense, syntax highlighting, autocomplete, error highlighting, F1 help, and brace matching. According to the Analysis Services Team, "The DAX Editor can be used to write standalone DAX queries or you can use the DAX Editor to extract measures from a BIM file, edit measures, and then save measures back to a BIM file."

The DAX Editor is available as an officially-unsupported sample, and the Analysis Services Team is requesting feedback on the new project. More information and a download can be found at CodePlex.

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT