Forum Discussion

Uzaring's avatar
Uzaring
Frequent Visitor
4 years ago
Solved

Problem with exponential data

Hi guys how are you?   I'm having some issues with a CSV that have some Id in exponential formats, like this: 1.15E+18 When I get this CSV with Power BI, the Query Editor interprets them well as a...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    Uzaring,

     

    Try this in a custom column in Power Query:

     

    Number.ToText(Number.From([Column1]))

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

Uzaring,

 

Try this in a custom column in Power Query:

 

Number.ToText(Number.From([Column1]))