Forum Discussion

Kim_GA's avatar
Kim_GA
New Member
3 years ago
Solved

Table.ReplaceValue with if statement

Hello, 

 

PowerBI novice who cannot make this code work. I want to replace any text <> 1101 in the column EEO_BPLACE with 'Outside Australia" and text = "1101" with "Australia". 

 

I've tried multiple versions and got multiple errors, this version doesn't error, but it also doesn't work. Nothing happens.

 

= Table.ReplaceValue(#"Changed Type7", each [EEO_BPLACE], each if [EEO_BPLACE] <> "1101" then "Outside Australia" else "Australia", Replacer.ReplaceText,{"EEO_FIELD_1"})

 

Help appreciated, thank you.

Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Try using Table.TransformColumns instead

     

    = Table.TransformColumns(Source,{{"TextColumn", each if _ = "1101" then "Australia" else "Outside Australia", type text}})

     

    Pat

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    Try using Table.TransformColumns instead

     

    = Table.TransformColumns(Source,{{"TextColumn", each if _ = "1101" then "Australia" else "Outside Australia", type text}})

     

    Pat