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 »


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


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:


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.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Latest Changes

[Jul 23, 2021] Fixed supported syntax for *NONBLANK* functions

Functions like FIRSTNONBLANK were not accepting a table constructor in the first argument, now that syntax is supported.

[Jul 7, 2021] Added support to datetime literals

The new syntax for date and time literals is now supported, like dt”1999-12-31″ and dt”2021-05-24T12:00:00″

[Mar 30, 2021] Support for new CROSSFILTER arguments

Added support to new CROSSFILTER arguments for cross-filter types.