Forum Discussion

rotni's avatar
rotni
New Member
6 years ago

Sharepoint online list

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)?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

  • dax's avatar
    dax
    Community Support
    6 years ago

    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.