[Jul 24, 2022] Support missing values in DATATABLE data
The syntax of DATATABLE allows data to skip columns – the value is considered blank. Such a syntax was not recognized by DAX Formatter before.
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 syntax of DATATABLE allows data to skip columns – the value is considered blank. Such a syntax was not recognized by DAX Formatter before.
The new function NETWORKDAYS is formatted correctly.
The CALCULATIONGROUP script syntax was not formatted only when there was at least one property. Now it works also without properties.