Table Transformation

Hi newhopepdx ,

In terms of your data structure as an ouput from Power Query, your data is in the optimal format to be used by the data model.

You should look into the PATH DAX functions in order to display this data how you want to:
https://learn.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax 

Pete

Ah, ok. So you're essentially trying to build a dimension(ish) table.

In that case, you can add level columns like this:

Level_1 = 
VAR __path = PATH(Table1[AccountId], Table1[ParentAccountId])
RETURN
CALCULATE(
    MAX(Table1[Name]),
    FILTER(
        Table1,
        Table1[AccountId] = VALUE(PATHITEM(__path, 1))
    )
)

Unfortunately you'll need to create one for each level of your hierarchy, but I think it does what you're after.

Output:

Pete