How to create a supervisor hierarchy table:

Hi, BBHouston , you might want to try a solution in Power Query

let

    Path = (emp) as text => 
        let
            sup = suplist{List.PositionOf(emplist, emp, Occurrence.First)},
            recursion = if List.PositionOf(emplist, sup) = -1 then "" else @Path(sup) & "|" & sup
        in
            recursion,

    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCqpMzFPSUVKK1YlW8k0sKslIBPLAgiAR16LMZBQBl8SyzBSgAFQpSCg4MTcxD6IPohwk6F2Zk4oQiAUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Staff Name" = _t, Supervisor = _t]),
    emplist = List.Buffer(Source[Staff Name]),
    suplist = List.Buffer(Source[Supervisor]),

    #"Added Hierarchy" = Table.AddColumn(Source, "Lv", each Path([Staff Name]) & "|" & [Staff Name]),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Added Hierarchy", "Lv", Splitter.SplitTextByDelimiter("|", QuoteStyle.Csv), {"Lv0", "Lv1", "Lv2", "Lv3"}),
    #"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"Staff Name", "Supervisor", "Lv0"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Lv3] <> null))
in
    #"Filtered Rows"

Please see this article on how to use the PATH function to do this.

On the Right PATH() - A DAX/Power Query approach to working with parent/child hierarchies. - P3 (powerpivotpro.com)

Regards,

Pat