Replace only null value with 2 conditions

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"})

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...