cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Replace blanks with null

Dear friends

 

i need to fill down column but its cant because its not "null" how can i convert blank cell into null.

thank in advance for any suggestions.

 

 

Screenshot (19).png

 

1 ACCEPTED SOLUTION
manikumar34
Solution Sage
Solution Sage

@Anonymous , 

Use replace to achieve this. 

manikumar34_0-1606380016791.png

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.





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous , null is blank in power query. Unless it is text null. If it text null then replace it null

or replace "" with null

https://www.howtoexcel.org/power-query/bulk-replace-values/

https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
manikumar34
Solution Sage
Solution Sage

@Anonymous , 

 

Awesome , you got the answer.

 

Your kudos will be appreciated 😊

Regards, 

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




manikumar34
Solution Sage
Solution Sage

@Anonymous , 

Use replace to achieve this. 

manikumar34_0-1606380016791.png

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.





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Anonymous
Not applicable

thanks a lot @manikumar34  its work!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors