Forum Discussion
Solved
Creating a new column using either custom or conditional column value
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 St...
Hi Roy_tap
add a custom column
if [Step Name]="Step b" or [Step Name]="Step d" then [Step a] else [Last Update]
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