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. ...
- 3 years ago
pls try this
List.Max({[Id],[Identifier]})
Ahmedx
Super User
3 years agopls try this
List.Max({[Id],[Identifier]})