Forum Discussion
Post ProdigyPATH is not working
Hi all!
I have a simple multi level parent child table:
Parent - child
Now I would like to get the levels for each combination by using PATH as described here:
https://www.daxpatterns.com/parent-child-hierarchies/
But I always get this error if I use PATH:
The value 'ABC' in 'Table'[Child] must also exist in 'Table'[Parent]. Please add the missing data and try again.
How can I adjust the table to get this working?
Hi,
Double check that all values in parent column (besides blanks) exist in the child column. Also check if your data types match. If they don't match this error can be encountered.
E.g. Both my columns are numbers:Now the columns are text:
The error appears here since the blank isn't null in PQ:
When I add nul to PQ the text also works:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
1 Reply
- ValtteriN
Community Champion
Hi,
Double check that all values in parent column (besides blanks) exist in the child column. Also check if your data types match. If they don't match this error can be encountered.
E.g. Both my columns are numbers:Now the columns are text:
The error appears here since the blank isn't null in PQ:
When I add nul to PQ the text also works:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/