Forum Discussion

H_insight's avatar
H_insight
Helper V
4 years ago
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.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

Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this

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

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Use this

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