topic Re: error when converting text to number in Power Query

error when converting text to number

Anonymous — Fri, 18 Feb 2022 22:05:09 GMT

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

Re: error when converting text to number

Anonymous — Sat, 19 Feb 2022 12:59:57 GMT

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

Re: error when converting text to number

v-angzheng-msft — Tue, 22 Feb 2022 05:54:26 GMT

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.

Re: error when converting text to number

kumar27 — Wed, 13 Mar 2024 04:35:24 GMT

This worked out perfectly , Thanks