DAX formatter and 'tablename'

[smedv1]

If i use DAX-Formatter, then tablenames with '..' are removed
I have a status table with name status - as this is a reserved word, i have to write it with 'status'
when i use the DAX-Script function and the DAX-formatter symbol then 'status' is replaced with status, which results in an error in Power BI.

Tabular Editor 3, version: 3.10.1
Tabular Editor 3 edition: [Desktop]

[mlonsk]

Hi @smedv1

This is a bug, thank you for reporting it. We will fix it in our next release.

[otykier]

Curse Microsoft for not properly documenting which names are reserved keywords :-(

[smedv1]

Ok, fine - by formatting with the dax formatter just leave the ' untouched, so don't have to deal with reserved keywords - but yes its annoying, that status seems to be an undocumented reserved word ;-)

[otykier]

It's a matter of ensuring consistent code style - that's why the built-in DAX formatter may change how tables are quoted. By default, the formatter will only quote table names when they are needed (reserved keywords, table names containing special characters or spaces, etc.). But if you enable Always quote tables under Tools > Preferences > DAX Editor > Auto Formatting, quotes will always be added.

[otykier]

This is now fixed in 3.11.0. Thanks for reporting!