[Sep 24, 2023] Fixed BLANKS DEFAULT in ORDERBY
The presence of BLANKS DEFAULT in ORDERBY was not properly recognized as valid DAX code.
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 »
The presence of BLANKS DEFAULT in ORDERBY was not properly recognized as valid DAX code.
The presence of LAST parameter in RANK and ROWNUMBER was causing an error for an additional “)” in the formatted code.
The RANK function was not recognized correctly.