cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DrDiHai Frequent Visitor
Frequent Visitor

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

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...?

1 ACCEPTED SOLUTION

Accepted Solutions
DrDiHai Frequent Visitor
Frequent Visitor

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

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 Smiley Tongue.

1 REPLY 1
DrDiHai Frequent Visitor
Frequent Visitor

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

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 Smiley Tongue.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 187 members 2,000 guests
Please welcome our newest community members: