Forum Discussion
[SOLVED] Major bug in DAX function for excel 365 home
- Sep 07, 2023by any chance is your computer set to a locality that uses 1.000,00 instead of 1,000.00? Have you tried using ; as the parameter separator?
- FredDFSep 07, 2023Copper Contributor
mtarler I suspected that. Separator are not underlined with error unless I use ; instead of ,
My PC is set to use , as list separator.
But yes, I kept the french format for 1 000,00 instead of 1,000.00.
And I use dot in excel option.
After your message, I set the regional setting to English (us) and restart the PC then set excel to use system separators. It solved the issue.
I’m gonna do more tests to see if I can only change the number format on my PC to fix this. It never was an issue until I use DAX. I wonder if I change my office language to french and reset the regional settings to french, if DAX would still complain. I prefer using office in English because I don’t like excel translate its function name. Thanks.
Edit : After further tests, if you set office in English, you can keep your French regional settings. But you need to change these. Decimal symbol as a dot (for currency too). List separator : comma.Then use system separator
You need to restart your PC after those changes.