Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Fill down won't work for Power Query Transform

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.

 

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

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

     

    Please try.

     

    Aiolos Zhao