Forum Discussion

JaclynPugh2022's avatar
JaclynPugh2022
Icon for Helper II rankHelper II
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!

 

Need Help
Tips and Tricks
  • m_alireza's avatar
    m_alireza
    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

2 Replies

  • m_alireza's avatar
    m_alireza
    Icon for Solution Specialist rankSolution Specialist
    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