Fill down non null values

Hi Chrisjr 

Please do the followng in Power Query:

base table

add a custom column

try (if Number.FromText([Column]) > 0  then null else null) otherwise [Column]

*you can also take something like <> 0  if you also have values below 0

Execute the fill

Delete the old column

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

Chrisjr , just adding to Mikelytics  solution. If you want to replace the values and do the fill down in a same column without duplicating and deleting the columns, Please try the below code in your replace value step.

= Table.ReplaceValue(Source,each [Name],
each if Number.FromText([Name]) > 0 then null else [Name],
     Replacer.ReplaceValue,{"Name"})

Thanks,