Forum Discussion
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 mul...
Try using Table.TransformColumns instead
= Table.TransformColumns(Source,{{"TextColumn", each if _ = "1101" then "Australia" else "Outside Australia", type text}})
Pat
Try using Table.TransformColumns instead
= Table.TransformColumns(Source,{{"TextColumn", each if _ = "1101" then "Australia" else "Outside Australia", type text}})
Pat