Table.ReplaceValue() not removing currency symbol in Dataflow breaking type conversion

[Anonymous]

In a Dataflow, I have a table containing the [Value] column, which looks like this: 

Value

24.572,02 €

4.501,02 €

242,09 €

I tried using 

Table.ReplaceValue(#"Added Channel", " €", "", Replacer.ReplaceValue, {"Value"})

But it doesn't replace the symbol, which then breaks the following step which is a type conversion to decimal point. 

Any ideas on why this might be happening?

[BA_Pete]

Hi @Anonymous ,

Have you tried changing Replacer.ReplaceValue to Replacer.ReplaceText and also changing the replace to value from "" to null?

Pete

[adudani]

HI @Anonymous 
I think the engine is implicitly converting the data type if you are replacing the currency sign with blank/" ", because the whole column would then be filled with float/decimal type numbers.

reference article:  Power Query M type system - PowerQuery M | Microsoft Learn

instead of replacing, you could even split column by delimeter if required instead for other purposes.

Appreciate a thumbs up if this is helpful.