DISTINCT with a table expression
Added support for DISTINCT syntax with a table expression. For example, DISTINCT ( UNION ( a, b ) ) is now formatted correctly (it was generating a syntax error before).
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 by SQLBI 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>
Added support for DISTINCT syntax with a table expression. For example, DISTINCT ( UNION ( a, b ) ) is now formatted correctly (it was generating a syntax error before).
The USERPRINCIPALNAME function available in Power BI is now supported.
The ISCROSSFILTERED function can receive a table argument instead of a column.
The order by arguments in CONCATENATEX are now supported. At the moment ASC/DESC are mandatory in DAX Formatter, even if they could be omitted in Power BI.
The syntax ‘tablename'[date column].[Year] is now supported. This syntax provides access to the level of hierarchies in automatic date tables created by Power BI.
The DISTINCT function accepts also a table expression as an argument.
The CONCATENATEX function can have optional parameters to define the order of the table to use to concatenate values in a string.
The new DATATABLE function is now supported by DAX Formatter.
Fixed security issue found by Suraj Sawant (Paladion Networks).
The TOPN function now accepts ASC/DESC for sort direction parameter (it was 0/1 or FALSE/TRUE in past versions of DAX, Power BI Desktop introduced the new syntax).
TOPN can be called with only two arguments in Excel 2016, Power BI Desktop, and SSAS 2016. DAX Formatter now supports this syntax.
If a comma separator was used in measure name requesting a forma with UK/EU settings, the comma was replaced by a dot in the formatted code. Now the original measure name in a measure definition is kept as-is in the formatted code.
Complete support of new DAX syntax in Excel 2016 and Power BI Desktop.
A few arguments in RANKX and TOPN were considered optional, whereas they are mandatory, accepting a syntax that was not valid in DAX.
The assignment can be made by using ‘=’ instead of ‘:=’, as implemented in Power BI Desktop.
Discussion
Accept our use of Cookies »