Forum Discussion
Solved
Issue with Decimal Separator in DAX Formulas ( function SQRT)
Hello, I'm experiencing an issue with my DAX formulas in Power BI due to the decimal separator used in my locale. In my locale, we use a comma (,) as the decimal separator. However, it seems ...
Martin_2 , First of all check what value is this giving
(Pivot_Result[Average Lead time (Month)] * POWER(Pivot_Result[StdDeviation], 2)) +
POWER((Pivot_Result[Average / Month] * Pivot_Result[Average Lead time (Month)]), 2)and is that a number and falls in the range of SRT
if this part gives an error. means one of the value is not having correct data type
Hi Martin_2 ,
Please try to replace the commas with periods in Power Query, then load into Power BI.
In Power Query, you could do replace operation:
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.