Forum Discussion
unicorns
Helper II
3 years agoConditional 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
Community Champion
NewStep=Table.AddColumn(PreviousStepName,"Final_ID",each [ID]??[identifier])