Forum Discussion

unicorns's avatar
unicorns
Helper II
3 years ago
Solved

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. 

 

 

 

 

 

Need Help

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    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

     

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    pls try this

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