Fill down won't work for Power Query Transform

[Anonymous]

I have a table where I want to "Fill Down" some rows. I highlight the entire column and select Fill Down but nothing happens. A formula popls up that says = Table.FillDown(Source,{"Column1","Column6}) so I feel like I'm doing it right.

The error must be on my end or is there something wrong with my data? See screen shot with arrows I drew on where I want to apply fill down.

[amitchandak]

Is fill down not working for you. Same option in power bi edit query mode

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

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please replace your value to null, then you can use the Fill Down.

Please try.

Aiolos Zhao