Forum Discussion

unicorns's avatar
unicorns
Helper II
3 years ago

Conditional Column - take values from different columns if it exists

How could I write power query to achieve below? whichever column has value, it'll be listed in "Final ID" column.

If both ID and Identifier columns have values, then take ID column's value. 

 

 

 

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

    NewStep=Table.AddColumn(PreviousStepName,"Final_ID",each [ID]??[identifier])