Transform Data

[JohannesBier]

Hello all,

I have data in text form in a column (for example 5343.4 and 2.56e+006). When I transform to integer, it recognises the decimal place as the leading decimal place. If I divide the column after the separator point, the e representations lose their meaning. What solutions are there for this?

Best regards

Johannes

[Syndicate_Admin]

In Power Query.

[JohannesBier]

Where exactly do I have to enter this? In PowerQuery or PowerBI?

[Syndicate_Admin]

Use Int64.From()  and make sure to specify the culture correctly.