Forum Discussion
Replace blanks with null
Anonymous ,
Use replace to achieve this.
Leave Value to Find as empty and replace with null.
In M-Query it looks something like below.
= Table.ReplaceValue(#"Replaced Value","",null,Replacer.ReplaceValue,{"COLUMN"})
Try replacing the column name and add the above line in advanced editor else use the first step.
Regards, '
Manikumar
If you find this is helpful, Accept as a Solution and leave a like.
Solution SageAnonymous ,
Use replace to achieve this.
Leave Value to Find as empty and replace with null.
In M-Query it looks something like below.
= Table.ReplaceValue(#"Replaced Value","",null,Replacer.ReplaceValue,{"COLUMN"})
Try replacing the column name and add the above line in advanced editor else use the first step.
Regards, '
Manikumar
If you find this is helpful, Accept as a Solution and leave a like.
thanks a lot manikumar34 its work!