Sharepoint online list

[rotni]

Hi

When getting data from sharepoint online list and a calculated field, the data is shown as a text and 100.000000000000 (one hundred). Im trying to convert it to numbers but im getting errros (langauge setting is swedish).

How can i change the . to ,? or is there another solution how to solve it(change something in sharepoint or power BI)?

[dax]

Hi rotni, 

You could try to change computer region to swedish, then click column to change type-Using Locale to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @rotni ,

The second parameter of the Number.FromText function is culture.

I think in this case Number.FromText(txt, "en-US") or Number.FromText(txt, "en-GB") should help.

Kind regards,

JB