Forum Discussion
text to decimal conversion returns scientific notation for some numbers
I have a csv file that has a column that starts as a text column but is converted to a decimal. I trim and clean the column before I promote the header and change the type to decimal. For the numbers that have multiple decimal points, Power query displays the number as scientific notation. Should this be this?
This is the column before changing to type decimal
This is the column after changing to type decimal.
3 Replies
As long as the numbers are properly represented this is not a problem.
angelakephart , Open Data Transformation, Right-click on the table and open advance editor and change data type to number there, if it is not number
See if this dax function can help
Hi angelakephart ,
You can see these solutions
https://www.myonlinetraininghub.com/excel-forum/power-query/numbers-turn-scientific-in-power-query
https://community.powerbi.com/t5/Desktop/scientific-notation/td-p/302089
https://community.powerbi.com/t5/Desktop/How-to-stop-scientific-notation/td-p/564430
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
