Added support to GENERATESERIES function
Added support to the GENERATESERIES function (it is used in Power BI to generate tables for the What-If parameter).
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 to the GENERATESERIES function (it is used in Power BI to generate tables for the What-If parameter).
Added support to the TOPNSKIP function. The TOPNSKIP function is not documented, but it is generated by Power BI when user browse data in a table when designing a model.
You can include double quotes in a string literal by using two consecutive double quotes (“). For example, “Litware 20″” Box Fan E401 Black” is now a valid string.
The function SELECTEDVALUE is now supported. It’s a shortcut for IF ( HASONEVALUE ( Column ), VALUES ( Column ) ,
The argument after KPITARGETFORMATSTRING is now formatted correctly (it must be a string delimited by single quotes, the formatter syntax was erroneously expecting a string within double quotes).
The functions UNICHAR, DETAILROWS, ERROR, and USEROBJECTID are now supported.
The TREATAS 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.
Discussion
Accept our use of Cookies »