cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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 want that Power BI interpret the strings as scientific notation format numbers.

 

How can I do this?

 

thank you!

1 ACCEPTED SOLUTION

Yes, I found out that regional settings was the problem.

I switched to ENglish (US) and the problem was solved.

 

THank you anyway. 

View solution in original post

6 REPLIES 6
New Member

I tried the answers in this post but still get errors after changing the language to en-US

My numbers are in the format three digits E+single digit

like 303 E+3

or 97.6 E+3

what else can I do to not get Errors displayed?

Thanks for your help

 

Microsoft
Microsoft

Hi @rmx000000,

After test, I can change it to decimal number as follows. Please update your Power BI desktop to the latest version and check if it works fine.

1.PNG


Best Regards,
Angelia

Yes, I found out that regional settings was the problem.

I switched to ENglish (US) and the problem was solved.

 

THank you anyway. 

View solution in original post

Hi @rmx000000,

Congratulations, you have resolved your issue, please mark the right or helpful reply as answer, so more members like you will get help from here. Thanks for understanding.

Best Regards,
Angelia

Solution Sage
Solution Sage

This might be fixed if you go into the query editor and see what automatic transformations Power BI makes when you import them - if you eliminate the step where it's thinking they're strings, then hopefully you can define your columns to be decimal numbers at the outset and have Power BI correctly interpret your data

Community Champion
Community Champion

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 screenshotSome old screenshot

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors