Getting all child values for every parent value based on a column

Hi rp2022 I think you could add a function to fetch all child values recursively, starting from the given parent, and combine the results for hierarchical relationships.Something like this

(GetChildren as function) =>
let
    GetChildren = (ParentID as text, DataTable as table) =>
    let
        DirectChildren = Table.SelectRows(DataTable, each [Parent] = ParentID),
        FurtherChildren = Table.Combine(
            List.Transform(
                DirectChildren[Child], 
                each @GetChildren(_, DataTable)
            )
        ),
        Result = Table.Combine({DirectChildren, FurtherChildren})
    in
        Result
in
    GetChildren