presents
Data Analysis Expressions (DAX) is a formula language introduced by Microsoft in Power Pivot and Analysis Services Tabular to define calculations and queries.
DAX Formatter is a free tool that transform your raw DAX formulas into clean, beautiful and readable code.
The syntax rules used improves the readability of the expressions, if you want learn more read the article: Rules for DAX Code Formatting.
If you use DAX Formatter for your posts, please embed our badge:
<a href="http://www.daxformatter.com?utm_source=badge-light&utm_medium=ad&utm_campaign=embed"><img src="http://www.daxformatter.com/wp-content/themes/daxformatter/images/daxformatter-badge-small-light.png" alt="DAX Formatter by SQLBI"></a>
<a href="http://www.daxformatter.com?utm_source=badge-dark&utm_medium=ad&utm_campaign=embed"><img src="http://www.daxformatter.com/wp-content/themes/daxformatter/images/daxformatter-badge-small-dark.png" alt="DAX Formatter by SQLBI"></a>
Table names having function names where not detected by DAX Formatter unless included within single quotes. Now the behavior has improved and function names can be used in DAX Formatter as table names even without single quotes.
Added a raw HTML version of DAX Formatter. Certain corporate policies do not allow using the scripts we use for a better user experience. You can use the HTML-only version at this address: http://www.daxformatter.com/raw
Also fixed minor bugs in URL syntax (there was an error using single quotes in DAX syntax).
There was a missing space before the close parenthesis of USERELATIONSHIP function when it was inline.
When a formula was pasted from OneNote or Power Point, a few non standard characters were included (such as 0x0b and 0xa0). These characters are now replaced with spaces in the input before formatting, so the formula is correctly parsed and displayed.
Certain table expressions that are converted in scalar values were not previously supported. An internal refactoring of the grammar supports now this type of conversion. As a side effect, certain syntax errors are no longer recognized by DAX Formatter, but this could be considered a benefit, because DAX Formatter now correctly format a certain number of invalid DAX syntaxes (that will generate errors once executed, anyway).
Floating point number starting or ending with “.” are now correctly recognized
The DAX query can have parameters with the prefix @
Using RELATED within EARLIER or EARLIEST was not recognized as a valid syntax.
In case the formatted query does not display in the browser page, the buttons to copy/edit/create new query are visible also in the upper area of the screen.
Fixed a grammar bug that was not recognizing the usage of ROLLUP function in case it had columnlist before and after the ROLLUP function call.
You can include comments (single line with // and multiple lines with /* … */ ). Comments at the end of an expression are not recognized. Comment position might be moved according to formatting. Please submit any bug on comment Handling, thanks!
If the third argument in FIND function was missing, and the fourth was present, the formatting did not recognize a valid syntax.
Now it splits only two binary operators in the same expressions. To be improved, implementing different logic for logical, comparisons and arithmetical operators.
Discussion