Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

PATH 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...
Need Help
  • ValtteriN's avatar
    ValtteriN
    3 years ago

    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/




ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

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/