[Jun 17, 2019] Fixed column variation without table name
The syntax for column variation now work even if the table name is not specified in the syntax.
table[col].[year] worked also before the fix
[col].[year] didn’t work before the fix
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 »