[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.
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 »