Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

error when converting text to number

Community, I am trying to convert text to number (or currency). I am still very new to Power Query so i am sure this is somethign rpetty simple but i literally spent 5h trying to figure it out 😞 

 

please help

 

 

 

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    I would Select the columns Amount 1 and Amount 2, right click, and choose   Change Type, then Using Locale, and then select whichever locale, but United States or us-En (I can't remember the parameters but it's a dropdown). Then select "Currency" as the type.

     

    Good Luck!


    --Nate

3 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, Anonymous 

    Select the target column, click the Data Type drop-down option in the UI to select the data type you want, or click Detect Data Type.
    If you can't convert to numeric type successfully, there may be invisible non-printing characters in the column. You can click the format drop-down option in the UI, select Trim in the options, and then convert the data type.

    Tip: Data is left-aligned for text types, and right-aligned for numeric types.

     

    If you need to format the data in the column as currency, select the column in PowerBI and click the format icon in the UI.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

    • kumar27's avatar
      kumar27
      Advocate V
      2 years ago

      This worked out perfectly , Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I would Select the columns Amount 1 and Amount 2, right click, and choose   Change Type, then Using Locale, and then select whichever locale, but United States or us-En (I can't remember the parameters but it's a dropdown). Then select "Currency" as the type.

     

    Good Luck!


    --Nate