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:
- EVALUATE <exp>
- Table[column] = <exp>
- Table[measure] := <exp>
- Table = <exp>
- [measure] := <exp>
- [measure] = <exp>
- measure := <exp>
- measure = <exp>
- = <exp>
- <exp>
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 agreeing 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.
