Forum Discussion
Replace only null value with 2 conditions
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..
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...
5 Replies
Oke it works just now
Thank you!
I'm glad it works now!
You're welcome
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?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...
