Replace values for certain items in another column

[Syndicate_Admin]

Hello,

I want to replace some of the values of one column when it matches values from another query (table). I know I can use merge queries and conditional columns, but I do not want to use replace values.

E.g in the table below I need to replace the Department from "-" to "Sales" but not for every value in the Name column. Instead, I want to be able to provide the table with the names concerned (e.g just for Leo and Ken).

Any help is highly appreciated 😊

Name       Department

Josh	IT
Nathan	Services
Leo	_
Margaret	_
Ken	_
Denis	IT
Flora	Services
Sandra	Services

[Syndicate_Admin]

Works like a charm. Thanks a lot 😊

[slorin · Accepted solution]

Hi

With Exception = {"Ken", "Leo"}

= Table.ReplaceValue(
   Source,
   each [Name],
   each [Department],
   (row,name,dep)=> if List.Contains(Exception,name) and dep="_" then "Sales" else dep,
   {"Department"}
)

Stéphane