Creating a new column using either custom or conditional column value

[Roy_tap]

Hi,

I have an existing import table containing of date values as such:

Process	Step Name	Last Update	Step a	Step b	Step c	Step d
P1	Step a	01-01-01	01-01-01
P2	Step b	07-07-01	03-03-01	07-07-01
P3	Step a	02-02-01	02-02-01
P4	Step d	06-06-01	04-04-01			06-06-01
P5	Step c	05-05-01	03-03-01		05-05-01

How can I create a new column to replace the Last Update column in the Query Studio to meet the following condition:
When Step Name = Step b, Last Update will be replace with Step a value

When Step Name = Step d, Last Update will be replace with Step a value

Else = Last Update value

Final table should looks like this: (Highlighted value is the updated value)

Process	Step Name	Last Update	Step a	Step b	Step c	Step d	Last Update1
P1	Step a	01-01-01	01-01-01				01-01-01
P2	Step b	07-07-01	03-03-01	07-07-01			03-03-01
P3	Step a	02-02-01	02-02-01				02-02-01
P4	Step d	06-06-01	04-04-01			06-06-01	04-04-01
P5	Step c	05-05-01	03-03-01		05-05-01		05-05-01

Thanks.

[watkinnc]

In the formula bar, type:

= Table.AddColumn(NameOfPriorStep, "Last Update 1", each if [Step Name] = "Step b" then [Step a] else if [Step Name] = "Step d" then [Step a] else [Last Update])

--Nate

[Vera_33 · Accepted solution]

Hi @Roy_tap 

add a custom column

if [Step Name]="Step b" or [Step Name]="Step d" then [Step a] else [Last Update]