Copy column in Power Query based on condition

[Anonymous]

Hi,

I have a dataset similar to the below.

Supervisor	Area	Block
Alan	1	1A
Marc	2	1B
Alan	3	1C
John	4	1C
Fred	5	2
Fred	5	4

I want to create a new column called 'Supervisor new' which copies over the data from supervisor but with the below condition.

If 'area' = '1' change 'Supervisor new' to "Alex"

If 'block' = '1b' or '1C' or '2" change 'Supervisor new' to "Dan"

Can anyone help me with the logic to achieve this?

[Coriel-11]

Try entering this into the box that comes up when you click "Custom Column"

if [Area] = 1 then "Alex" else 
if [Block] = "1B" then "Dan" else 
if [Block] = "1C" then "Dan" else
if [Block] = "2" then "Dan" else
[Supervisor]

[johnt75]

In power query editor go to the Add Column tab and select Conditional Column. You can put your logic in there.

[Anonymous]

After playing around with the conditional column function, I do not see how this can be achieved due to the 'Else if' section not supporting 'and' statements.

Any ideas?

[johnt75 · Accepted solution]

you could edit the code in Advanced Editor. put the basic logic in using the Conditional Column functionality and then edit the code that is generated to add in any additional logic you need.