0

I'm looking into the Parent Child Hierarchy in PowerPivot/DAX. Below are some useful articles I have found.

parent-child-hierarchies-in-tabular-with-denali

PowerPivot Denali: Parent child using DAX

PATH Function (DAX)

However, when I tried to implement the PATH function in DAX, I got the following error.

=path(rptHierDate_rptHierDate[TREE_NODE_ID],rptHierDate_rptHierDate[PARENT_TREE_NODE_ID])

Error

Below is a screenshot of my dataset. I have checked column TREE_NODE_ID has no duplication, and all values in column PARENT_TREE_NODE_ID exist in TREE_NODE_ID

enter image description here

I'm not sure why am I getting this error. Any idea is appreciated!

qshng
  • 887
  • 1
  • 13
  • 32
  • Are you sure parent values exist in the tree column? Maybe they are the same at a glance but trailing/leading spaces could be causing the error. – alejandro zuleta Oct 17 '16 at 20:36
  • Yes, I used the `MATCH` function in Excel to check the source data, and all parent_node_id have a match in the node_id – qshng Oct 17 '16 at 20:49

0 Answers0