Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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.
This worked out perfectly , Thanks
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.