Forum Discussion

Dillinger's avatar
Dillinger
Frequent Visitor
4 years ago

Localized Dax Separators Not Working

Hi,   I had to reinstall PBI Desktop due to a matter which later proved to be a bug in October release (missing DAX editor function parameter suggestions).   After the reinstall, I cannot get the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Dillinger AGo ,

 

I was told the October Desktop version has been updated yesterday. It has been optimized for DAX IntelliSense issues.

Check if the situation you mentioned has improved. if not, please consider to post it to the Issues forum.

https://community.powerbi.com/t5/Issues/idb-p/Issues.

 

Best Regards,

Jay

Dillinger's avatar
Dillinger
Frequent Visitor
4 years ago

Anonymous , thanks for the notice.

 

I opened my data model in PBI Desktop and interesting things happened:

 

1. DAX editor notified that the commas (separators) were erroneous in the syntax

2. I changed the erroneous commas into semicolons and the DAX editor now approved the semicolons

3. I saved the DAX syntax but the measure began giving the error! trigon

4. I went to check the syntax again and Power BI had changed the semicolons to commas or even periods

 

Most interesting thing was that the measures were initially shown in visuals when the separator was comma and DAX editor was notifying error for the commas. Right after I changed the commas to semicolons and saved the syntax/measure, visuals didn't show the measures anymore and returned error. Apparently because Power BI changed the semicolons back to commas or periods right after saving the measure.

 

So the update seems to have given half a solution to the matter. DAX editor now approves the semicolons as separators but when saving the syntax's/measures, the Power BI changes the separators back to commas.

 

I'll try to reinstall Power BI Desktop once again and report here what happens.

  • Dillinger's avatar
    Dillinger
    Frequent Visitor
    4 years ago

    Anonymous 

    Referring to my earlier post today 29th October, I reinstalled Power BI Desktop via Microsoft Store and the problem I desrcibed yet exists where DAX editor accepts semicolon as separator but right after I save the measure, Power BI changes the semicolons into commas and the measure itself returns error.

     

    So Power BI Desktop is practically now useless if I choose to use the localized separator. Workaround is ofcourse to force the separator to be comma. I just think Microsoft should remove the option for using localized separator if the option simply doesn't work.

     

    I'll post my problem to Issues forum as you instructed. So no complete solution yet in the matter.

     

    Thank you for helping.