DAX Formatter by SQLBI

Separators

Choose the list/number separators.

Automatic
US/UK A, B, C, 1234.00
Others A; B; C; 1234,00

Spacing

Manage spaces after function names.

Best practice
Space after function IF (
No space after function IF(

Lines

Show more or fewer arguments on one line.

Long lines
Short lines

Light

Settings

Copy Copy HTML Save as DOCX Edit New

Bug Report

Format Copy Copy HTML Save as DOCX Edit New

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 …
Table[column] = …
Table[measure] := …
[measure] := …

[measure] = …
measure := …
measure = …
= …

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.

Discussion

Expand comments

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.

Latest Changes

[May 28, 2020] Added identification of query parameters

Querey parameters have a different color and are identified by the QueryIdentifier tag in the coloring scheme.

[May 14, 2020] Added support to NORM functions

Added support to NORM functions in DAX.

[Apr 23, 2020] Improved syntax of SAMPLECARTESIANPOINTSBYCOVER and SAMPLEAXISWITHLOCALMINMAX

The functions SAMPLECARTESIANPOINTSBYCOVER and SAMPLEAXISWITHLOCALMINMAX are used in Power BI queries and their syntax was not recognized correctly, now DAX Formatter should cover more use cases.