Forum Discussion

Mars3442's avatar
Mars3442
Helper I
2 years ago
Solved

Replace only null value and 1 condition

Hi everyone, I want to ask a help for solving my problem I have a table like this I need to replace the null value with these conditional : Order = Arrive, the status = delivered Without r...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    Hello, Mars3442 try custom replacer function

    Table.ReplaceValue(
      stepbefore, 
      "", 
      each ([Order Qty] = [Arrive qty]) and ([Status] = null),
      (value, old, new) => if new then "Delivered" else value, 
      {"Status"}
)
AlienSx's avatar
AlienSx
Super User
2 years ago

Hello, Mars3442 try custom replacer function

Table.ReplaceValue(
      stepbefore, 
      "", 
      each ([Order Qty] = [Arrive qty]) and ([Status] = null),
      (value, old, new) => if new then "Delivered" else value, 
      {"Status"}
)