Forum Discussion
Solved
scientific notation
Hi, I have a csv file with two columns : column A, column B 1.5554E-43, 4.2039E-45 Power BI assumes that both columns are strings. If I change them to number, it gives an error. I...
Yes, I found out that regional settings was the problem.
I switched to ENglish (US) and the problem was solved.
THank you anyway.
Probably your culture code expects decimal commas. In that case, you need to provide a culture code when transforming to number type, e.g. "en-US":
= Table.TransformColumnTypes(NameOfYourPreviousStep,{{"column A", type number}, {"column B", type number}}, "en-US")
This can be done by using "Using Locale":
Some old screenshot