Forum Discussion

mickeydjw's avatar
mickeydjw
Frequent Visitor
8 years ago
Solved

Alternative for LOOKUPVALUE in M

Scenario:  I have a dataset with Work Item ID and Parent Work Item ID.  I'm trying to create a hierarchy within the 2 to build some reports.  When I try to set it up, I receive the error that the Par...
Need Help
  • mickeydjw's avatar
    mickeydjw
    8 years ago

    Thanks to those that helped.  I facepalmed when I figured it out.  Instead of setting the PATH parent as Parent of Work Item, I set it to New Parent ID.  Problem solved.

mickeydjw's avatar
mickeydjw
Frequent Visitor
8 years ago

In which format?  Excel table?  I'm not certain what specific data I can and can't share.  The columns I'm concerned aboutt are Work Item ID and Parent Work Item ID.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

You can put data in excel, only relative column or share  sample data here in forum