Forum Discussion
replacing values
Power Query has nothing like implicit type conversion, so if you want to convert text to numbers, then you need to change type.
If your number format differs from the format in the text, then you can change the type and choose Using Locale..
Next supply the culture code that conforms to your input format, i.c. e.g. English (United States).
Generated code (step 2 is the result from the pictures above):
let Source = #table(type table[price total = text],{{"15.02"},{"15.02"},{"5.97"},{"5.97"}}), #"Changed Type with Locale" = Table.TransformColumnTypes(Source, {{"price total", type number}}, "en-US") in #"Changed Type with Locale"
Hi RobbeVL
If you want to convert text to a decimal number you can simply do so by going to query editor and selecting decimal number format, like shown in the picture below:
If I am right it will transform "." to "," automatically.
Another option is to use the function "replace values" (also in the query editor) like shown in the picture below:
Regards,
L. Meijdam,
Power Query has nothing like implicit type conversion, so if you want to convert text to numbers, then you need to change type.
If your number format differs from the format in the text, then you can change the type and choose Using Locale..
Next supply the culture code that conforms to your input format, i.c. e.g. English (United States).
Generated code (step 2 is the result from the pictures above):
let Source = #table(type table[price total = text],{{"15.02"},{"15.02"},{"5.97"},{"5.97"}}), #"Changed Type with Locale" = Table.TransformColumnTypes(Source, {{"price total", type number}}, "en-US") in #"Changed Type with Locale"