Path - Show data only of Parent/Child

[thhmez7]

Hi,

in a matrix I'd like to display all Account data that have "child" or "parent" account. So I create PATH-functions as columns:

Path = PATH(Account[Account ID], Account[Parent Account ID])

Pathlength = PATHLENGTH(Account[path])

Path lev 1 = LOOKUPVALUE(Account[Account Number],Account[Account ID], PATHITEM(Account[path],1,TEXT))

Path lev 2 = LOOKUPVALUE(Account[Account Number],Account[Account ID], PATHITEM(Account[path],2,TEXT))

So in this case, the first two Account numbers (Path lev 1) with their child account numbers (Path lev 2) AND the blank row should be displayed. All other Account numbers should not be seen.

The difficult part for me is to show these blank rows as well while other Accounts who don't have a child-account should disappear.

Thank you.

[amitchandak · Accepted solution]

@thhmez7 , refer if this can help

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.