PowerBI/DAX uses Comma to separate arguments as well as a decimal point

[DrDiHai]

Probably as a result of a combination of unfortunate regional settings, DAX in powerBI has decided that a comma should separate both decimal numbers and function arguments. (At least, that's what I think the reason is)

For example, the following expression returns 2,10 (and no error!):

IF(TRUE(),2,1)

Adding e.g. a space before the 1 just creates an actual error.

Any idea what settings I need to adjust...?

[DrDiHai · Accepted solution]

Well, "solved" it pretty fast.

I had my "Regional Format" in Windows' "Region Settings" set to "English (Switzerland)". Switching to "German (Switzerland)" solved the problem (as now arguments are separated by semicolons).

Still, I'd say that's a pretty unfortunate combination to have anywhere .