Replace only null value with 2 conditions

[Mars3442]

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 :

Purchase number= null, Purchase 2 number = null, the status = No Data

Without replace the cell that have been filled

My expectation table like this

What M Code I should write to get my expectations?

Please help me to solve this problem

Thank you..

[mlsx4 · Accepted solution]

Hi @Mars3442 

Try this 

= Table.ReplaceValue(#"PreviousStepName",null,each if [Purchase number]=null and [Purchase 2 number]=null then "No data" else null,Replacer.ReplaceValue,{"Status"})

[Mars3442]

Oke it works just now

Thank you!

[mlsx4]

I'm glad it works now!

You're welcome

[mlsx4 · Accepted solution]

Hi @Mars3442 

Try this 

= Table.ReplaceValue(#"PreviousStepName",null,each if [Purchase number]=null and [Purchase 2 number]=null then "No data" else null,Replacer.ReplaceValue,{"Status"})

[Mars3442]

It returns

Expression.SyntaxError: Token Literal expected.

Table.ReplaceValue(#"PreviousStepName",
------> ^
null,each if [Purchase number]=null and [Purchase 2 number]=null then "No data" else null,Replacer.ReplaceValue,{"Status"}) 

what should I do?

[mlsx4 · Accepted solution]

Have you replaced the name of the previous step between ""? And the column name is "Status"?

For me, it's working perfectly.

Check also that previous line ends with a ",":

#previousStep=.........(.....),

#replaceNull= Table.ReplaceValue...