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", e...
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"})

     

     

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