Column creation by using If condition

[vijay22kar]

Hi All,

I have 4 different columns i.e user1, user2, set A, and set B

If set A = "WIP" then the New column should be as user1, else if set B = "WIP" then the New column should be as user2.

How to do this. Please help.

Thanks in advance.

[bcdobbs · Accepted solution]

Create a calculated column with following:

SWITCH ( 

   TRUE (),

   TableName[Set A] = "WIP", TableName[User 1],

    TableName[Set B] = "WIP", TableName[User 2],

    BLANK ()

)