Forum Discussion
Custom Item Hierarchy
abergman -
You should be able to implement similar to https://www.daxpatterns.com/parent-child-hierarchies/
This is a really good article. I read through it, and it seems to be focused on Excel. Does the solution apply to power BI as well? I'm having a difficult time implementing in Power BI. I created the PATH column, but don't know what to do after that.
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.
How do I set up the nodes key and parent key for my table?
Having trouble with the Node Keys and Parent Keys. My data set is essentially a bill of materials. I have one item that is composed of another item which is composed of another (3 levels total). These are broken down into item numbers.
I created my Path column fine, and my hierarchy depth column worked as well. But when I went to use the code to create my level columns, I used the following code and got an error. Any ideas? Thanks in advance.
abergman -
My guess is you have duplicate values in [SHORT_ITEM_NUMBER]. You should have two tables; one is the structure of the hierarchy and the other is your fact table. Possibly you can share your file?