Forum Discussion

rishghuwalewala's avatar
rishghuwalewala
New Member
3 years ago
Solved

Fill Down with a Condition

Hi Community,   Would anyone know how to fill down using incremental values from previous row. Example of the output I'm looking for is below:   What I have What I want 1 1 null 2 ...
Need Help
  • kirete17's avatar
    kirete17
    3 years ago

    Table.Group can be the solution

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = 
        Table.Combine(
            Table.Group( 
                Source, 
                "What I have", 
                { "q", each Table.AddIndexColumn( _, "What I want", 1, 1 ) }, 
                0, 
                (x,y)=> Byte.From( y <> "null" ) 
            )[q]
        )
in
    Custom1
kirete17's avatar
kirete17
Frequent Visitor
3 years ago

Table.Group can be the solution

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = 
        Table.Combine(
            Table.Group( 
                Source, 
                "What I have", 
                { "q", each Table.AddIndexColumn( _, "What I want", 1, 1 ) }, 
                0, 
                (x,y)=> Byte.From( y <> "null" ) 
            )[q]
        )
in
    Custom1