Unable to replace null values in one column ?

[suvechha]

Hi there, Unable to replace null value in the column.

Sample model attached.

https://1drv.ms/u/s!AhqwbtIVEKQ2b8mGSC8la64lBLM?e=rEqmc3

[Icey]

Hi @suvechha ,

Please let us know if the replies above are helpful.

If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please give us more details.

Best Regards,

Icey

[manikumar34]

@suvechha , update the below query in the formula bar

= Table.ReplaceValue(#"Duplicated Column","","Not Assigned",Replacer.ReplaceValue,{"Technician - Copy"})

If this works accept as solution and leave a like.

Regards, 

Manikumar

[CNENFRNL · Accepted solution]

@suvechha Generally speaking, that's a empty (zero-length) string instead of null (null is concrete value in PQ, which means "no value" for any data type).

You may try this