Forum Discussion

JdL42's avatar
JdL42
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Any idea why the Fill Down option does not work ?

I have a csv file and the first colum is filled each 6 rows. I try to use the fill down option but nothing appear. Any idea ?
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    No , there is no difference between this two null , when u try to replace empty with null it will consider normal null only. there no italic charcters. check with replace in power Query again and u can . see my previous post image

JdL42's avatar
JdL42
Icon for Advocate I rankAdvocate I
9 years ago

Thanks for your advice. In fact it seems to be different between "null" (italic = empty) and "null" when I replace this value.

In this cas, the fill down option doesn't work either.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Possibly you have double quotes around "null" in your formula? If you adjust the vales as indicated there shouldn't be double quotes around null.

  • JdL42's avatar
    JdL42
    Icon for Advocate I rankAdvocate I
    9 years ago

    Thank's for help. It was just an error between Null and null !

  • ablackmor's avatar
    ablackmor
    Regular Visitor
    8 years ago

    I know this is an old thread but it seems like Fill > Down should work for both blanks and null values--or include a checkbox to include or exclude blanks depending on the user's preference. Is this just an oversight?