Forum Discussion

Eric-De's avatar
Eric-De
Frequent Visitor
2 years ago
Solved

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

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

Need Help
  • ronrsnfld's avatar
    ronrsnfld
    2 years ago

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

     

     

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

     

     

2 Replies

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    2 years ago

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

     

     

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

     

     

    • Eric-De's avatar
      Eric-De
      Frequent Visitor
      2 years ago

      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