Forum Discussion

abergman's avatar
abergman
Frequent Visitor
6 years ago

Custom Item Hierarchy

All,   I am stuck on a project I'm working on. What I am trying to do is create a custom hierarchy for items and am not sure how to model the data.    I am currently setting up my table to look l...
Need Help
Tutorial Requests
ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Power Pivot uses DAX. Yes it applies to Power BI.

Are you reviewing the Complete Pattern? The only other bit that's not in the article, it's in the comments, is :

 

BrowseDepth:=
ISFILTERED ( Nodes[Level1] )
    + ISFILTERED ( Nodes[Level2] )
    + ISFILTERED ( Nodes[Level3] )
MaxNodeDepth:=MAX ( Nodes[HierarchyDepth] )

 If I recall correctly.

Then you'll make your own hierarchy to drag and drop Levels.

abergman's avatar
abergman
Frequent Visitor
6 years ago

How do I set up the nodes key and parent key for my table?