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