Data Analysis Expressions (DAX) is a formula language introduced by Microsoft in Power BI, Power Pivot and Analysis Services Tabular to define calculations and queries.

DAX Formatter is a free tool by SQLBI that transform your raw DAX formulas into clean, beautiful and readable code. The syntax rules used improves the readability of the expressions – learn more here: Rules for DAX code formatting »

A lightweight version of this tool (HTML only) is also available. Lite version »

Syntax

You can format any DAX query and expression in the form:

API

You can call the service via standard HTTP requests. How to use API »

Terms of Use

By using DAX Formatter by SQLBI you are agree to the following conditions:

• The service is provided “as is” without warranty of any kind.
• The query you write are sent to a server running on Windows Azure, which provide a service for syntax formatting.
• A few results of the query parser can be saved for statistical reasons (most used functions, complexity index, average length and others).
• The DAX Formatter rebuild the DAX query code based on the syntax tree and the result might not correspond to the original query.