Forum Discussion

FredDF's avatar
FredDF
Copper Contributor
Sep 07, 2023
Solved

[SOLVED] Major bug in DAX function for excel 365 home

1. Add a measure 2. write     =SWITCH(TRUE,yearly_synthesis[perfs]<100,"A",yearly_synthesis[perfs]<= 100, "B","C")     "A" and "B" are underlined as error and the measure can not be saved re...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Sep 07, 2023
    by 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?
mtarler's avatar
mtarler
Silver Contributor
Sep 07, 2023
by 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?
FredDF's avatar
FredDF
Copper Contributor
Sep 07, 2023

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. :facepalm: 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.

Resources