Forum Discussion

salgouda's avatar
salgouda
Frequent Visitor
3 years ago
Solved

Power Query replace column value based on another column

Hello there,   I am calculating employee retention and I need to change the null values in isActive column to be "false" if there's an end date which means the employee left, and "true" if end date...
  • ImkeF's avatar
    3 years ago

    Hi salgouda ,
    if you enter an equal sign just at the start, the formula should work.