Create hierarchy columns with DAX

The purpose of this example is to create columns in the Account dimension which will support a six-level hierarchy.

• The table is self-joined based on the AccountKey and ParentAccountKey parent account code

1. From the Data View, select the Account table and click on New Column from the Modeling tab.
2. Create a DAX calculated column to return the account name of the top most parent for the given account row

1. Create five additional calculated columns to support the additional levels of the hierarchy. 
   • In each calculation, revise the second parameter of the PATHITEM() function for the level of the hierarchy .
   • For example, the Account Level 3 column's PATHITEM() function should use (AccountPath,3,1).