Hire-achy Column in Power Bi

[Anonymous]

Is it possible to create Hireachy column by using DAX becacuse my source is tabular model since i am not able create in Power Bi level and i Don't have permissons to create in Model as well.

For example i have a table like Sales and columns like  Code and Description so i want create create hireachy columns by using code and description.

[Anonymous · Accepted solution]

Yes it is possible to create hierarchy column using DAX. Please read the article below -

Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX

Regards,

Kaushlendra Mishra

PowerBI Talks

[v-xuding-msft]

Hi @Anonymous ,

There is a similar thread about hierarchy with live connection.  It may not match your situtaion totally. Hope it will give you new ideas.

SSAS Tabular Date Hierarchies not working with Live Connection 

And you could vote up the following idea and submit comments to get the feature fixed quickly.

Date with no hierarchy with SSAS tabular live connection 

[v-xuding-msft]

Hi @Anonymous ,

Does that make sense? If so, please mark the helpful answer as solution. Then we will be able to close the case. More people who have the same requirement will find it quickly and vote it up.

Hope it will be implemented as soon as possible.

[az38]

@Anonymous 

hi

as I understand DAX doesn't have any statement that allow you to create hierarchy.

And I cannot imagine the scenario of DAX-generated hierarchy usage