Conditional Column - take values from different columns if it exists

[unicorns]

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. 

 

[Ahmedx · Accepted solution]

pls try this

List.Max({[Id],[Identifier]})

[Ritaf1983]

Hi @unicorns 

Please to achieve your goal you can add a conditional column like on bellow picture:

Result

Link to sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly