Added support to TREATAS function
The TREATUS function is now supported.
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>
The TREATUS function is now supported.
The comments after the last statement are now included in the formatted output. Please note that using DAX Editor the comments after a measure definition are always attached to the next object defined in the script.
The dates expression used in time intelligence functions can be a variable name, which has the same syntax of a table name.
Added support for a number of additional properties added in DAX Formatter for measure definitions, in order to support KPI definition.
A variable can be used in place of a literal, if the variable is assigned to a literal.
The use of variables (syntax VAR/RETURN) was not working if used in filter arguments of CALCULATE and CALCULATETABLE.
Added support for IN operator and minor improvements in properties for measure formats (for DAX Editor).
The UNICODE function is now supported.
Now SUMMARIZECOLUMNS formats correctly even when there are no columns before table expressions or aggregations, and/or when there are multiple tables before the aggregations.
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.
Discussion
Accept our use of Cookies »