used existing value(s) in a column to replace null value

[Eric-De]

Hello

I need to replace value null by previous value 

I have try something like this 

= Table.AddColumn(#"Added Index", "Custom", each Table.TransformColumns(#"Added Index", "Custom.2", each if Text.Contains([Custom.1], "" )
then
Table.SelectRows(Source, each [custom.1] <> "" and [index] = [index]-1)
else
[Custom.1]))

but my syntax is definitly wrong 

After check on the forum I have find some sample but apparently not the same usage than my needed.

If some people can help me to this ?

Best regards

[ronrsnfld · Accepted solution]

From your data sample, it looks like you could simply use the Table.FillDown function.

Table.FillDown(#"Previous Step",{"Custom.1"})

[Eric-De]

Bonjour / Hello

Thank to this ronrsnfld. I have arleady used this command but I think that take only the first value who exist, but not.

That solved my problem.

Thank to this 😀

Best regards