
New Member

March 16, 2022

I have data in numbers (with commas and a point and two decimals after the point) Excel that I imported on PQ. Once my data is on power query, they are in "any" format. When I try to put them in "currency" format, it displays an error message: "we couldn't convert to number".


Trusted Members
Moderators
Power BI

January 31, 2022

When you change the data type don't choose "Currency" directly. The format that the amounts come in is probably not the same as what you have have in local system settings. Change the data type by "Using locale" and then Currency and specify a format that matches the data source. Probably "English US" will work as that uses comma's as thousand-separators and decimal points.
More about in the attached link.
1 Guest(s)
