Forum Discussion

dukeof3arl's avatar
dukeof3arl
New Member
3 years ago
Solved

Replacing Text values using IF statements

Hey all,   I'm trying to replace values of a manager that has an incorrect manager assigned to a team member.  The manager and team member have their own separate columns.   Where "Joe Smith" is ...
Need Help
  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    3 years ago

    dukeof3arl ,

    Hi.

    Add a new column in power query.

    if [Manager Column] = "Joe Smith" and [Team Member] = "Jane Doe" then "Robert Regular" else [Team Member]

     Thanks

Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
3 years ago

dukeof3arl ,

Hi.

Add a new column in power query.

if [Manager Column] = "Joe Smith" and [Team Member] = "Jane Doe" then "Robert Regular" else [Team Member]

 Thanks

  • dukeof3arl's avatar
    dukeof3arl
    New Member
    3 years ago

    This is the answer!  However, you need to reverse the logic here.

     

    if [Team Member] = "Jane Doe" and [Manager] = "Joe Smith" then "Robert Regular" else [Manager]