Add prefix if value is number

[H_insight]

Hello,

I am trying to add a Prefix to Column1 only when the value in the column is a number.

I tried the below code to transform the column (without adding a new column):

= Table.TransformColumns(#"Changed Type", {{"Column1", each if Value.Is([Column1], Int64.Type ) then "$" & Text.From(_, "en-GB") else _}})

But I am getting an error: 

Any steer is greatly appreciated

[Vijay_A_Verma · Accepted solution]

Use this

= Table.ReplaceValue(#"Changed Type",each [Column1], each if Value.Is([Column1],type number) then "$" & Text.From([Column1]) else [Column1],Replacer.ReplaceValue,{"Column1"})

[H_insight]

@Vijay_A_Verma  Super thanks!