Forum Discussion

JaclynPugh2022's avatar
3 years ago
Solved

Power Query Custom Column Help Please

Hi, I'm trying to write a custom field that looks at [Late/Early/On-Time] and if there is an error I need it to populate with "Unconfirmed".  Any help would be appreciated.  Thank you!  
  • m_alireza's avatar
    3 years ago

    Hi JaclynPugh2022 ,

    Alternatively, you could right click on the column > Replace Errors...

    Then Type Unconfirmed and press ok. 
    That should replace the errors in your field with Unconfirmed