Forum Discussion
Solved
To replace multiple values in a single column in power query
Hello I have a column Mapped Account. I would like to Replace Values in the column with another for example replace 507010 with 502800 and 507020 with 502810. I know there is the Replace Values ...
Actually copilot answered my question!
= Table.TransformColumns( #"Changed Type1", { {"Mapped Account", each if _ = 507010 then 502800 else if _ = 507020 then 502810 else _ } } )
Actually copilot answered my question!
= Table.TransformColumns(
#"Changed Type1",
{
{"Mapped Account", each
if _ = 507010 then 502800
else if _ = 507020 then 502810
else _
}
}
)