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, read this article to learn more: Rules for DAX code formatting »


Syntax

You can format any DAX query and expression in the form:
  • EVALUATE …
  • Table[column] = …
  • Table[measure] := …
  • [measure] := …
  • [measure] = …
  • measure := …
  • measure = …
  • = …

API

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

Terms of Use

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

Discussion

DAX Formatter is not working as expected?
Please, fill out the form as completely as possible.

Note: the current formula will be automatically attached to the request.





Mastering DAX Video Course








Latest Changes

[May 6, 2018] Support for coloring variables

Variables have a different color. A variable name overrides a table name in DAX Formatter, whereas this cannot happen in DAX up to date.

[Apr 18, 2018] Added SHORT LINE / LONG LINE setting

The web user interface has a setting to enforce splitting the syntax on the first element, obtaining shorter lines (SHORT LINE). The standard behavior is to split only rows that have a single expression within the length of 80 characters (LONG LINE).

[Mar 27, 2018] Added support to SELECTEDMEASURE and SELECTEDMEASURENAME

Implemented support to SELECTEDMEASURE and SELECTEDMEASURENAME functions introduced in Azure Analysis Services on March 2018.




SQLBI

2006-2018 © SQLBI. All rights are reserved.
SQLBI is a trademark of SQLBI Corp.
Loader is the legal representative of SQLBI in Europe.
www.sqlbi.com

PRIVACY & COOKIE POLICY