Decimal Separator Issue in DAX: Automatically Replaces . with , Causing Errors with Static Decimal

[Bibiano_Geraldo]

Hello, Power BI community!

I’m encountering an issue with DAX related to the automatic replacement of the period (.) with a comma (,) in decimal numbers. When trying to write static decimal numbers, Power BI automatically replaces the period with the regional decimal separator (comma), which results in errors in the formula.

Example of the Issue:
When trying to use a number like 1500.75 in a DAX formula, Power BI automatically converts it to 1500,75, causing a syntax error as DAX doesn't recognize the comma as a decimal separator in some regional settings.

Has anyone else encountered this problem? Any suggestions on how to avoid or fix this issue?

 

[Anonymous]

Hi  @Bibiano_Geraldo ,

You may adjust the regional settings in Power BI to use a period (.) as the decimal separator. This can be done in the Power BI Desktop under File > Options and settings > Options > Regional Settings.
You may also try use the FORMAT function in DAX to explicitly format numbers with the desired decimal separator. For example, FORMAT(1500.75, "0.00", "en-US") will ensure the number is formatted with a period as the decimal separator.
In some cases, using double commas can be a workaround. For example, DATE(YEAR(MIN(Profit[Order Date])), 1,, 1)5.

Best regards.
Community Support Team_Caitlyn

[Bibiano_Geraldo]

Thank you @Anonymous!