Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Fill empty cell with value contained within the same column but with a condition within another colum

Hello everybody,   I'm starting my journey with PowerQuery and I'm currently facing an issue that could be solved with your suuport.   I have a table containing various requests (column id). Some...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hello,

Thanks for your quick answer.

After some adjustments to fit with my source file, it works perfectly :).

Now I have to adapt it to a bigger db !

Thanks a lot for your support :)!

Rémi

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago

    Great! By I should have started with something simple. Like Table.Group and Table.FillUp (or FillDown). Try this:

    let
    Source = your_table,
    #"Grouped Rows" = 
        Table.Group(
            Source, "parent_id", 
            {{"rows", each Table.FillUp(Table.Sort(_, "DATA"), {"DATA"})}}),
    #"Expanded rows" = Table.ExpandTableColumn(#"Grouped Rows", "rows", {"id", "DATA"})
in
    #"Expanded rows"