Forum Discussion

JaclynPugh2022's avatar
JaclynPugh2022
Icon for Helper II rankHelper II
4 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!  
Need Help
Tips and Tricks
  • m_alireza's avatar
    m_alireza
    4 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