Forum Discussion
Solved
Add prefix if value is number
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.T...
Use this
= Table.ReplaceValue(#"Changed Type",each [Column1], each if Value.Is([Column1],type number) then "$" & Text.From([Column1]) else [Column1],Replacer.ReplaceValue,{"Column1"})
Use this
= Table.ReplaceValue(#"Changed Type",each [Column1], each if Value.Is([Column1],type number) then "$" & Text.From([Column1]) else [Column1],Replacer.ReplaceValue,{"Column1"})Vijay_A_Verma Super thanks!
