Dataformat. Error: We Couldn't Convert to Number
Using Power Query, I'm Trying to Change the Type of a Column That Has Values Such as This into Decimal. but I Get the Following Error: Dataformat. Error: We...
Using Power Query, I'm trying to change the type of a column that has values such as this into decimal.
But I get the following error:
DataFormat.Error: We couldn't convert to Number.
This is when in my Advanced Options, the decimal separator seems to be . which is the one used in the column.
1 Answer
Try adding an index, then add a custom column with formula
=Number.From([Amount])
Filter that for errors and that will find you your problem data row
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
