Forum Discussion
Alternative for LOOKUPVALUE in M
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.
Super Usernot sure what the ask is? from your sample, all parent work item ids and in work item id. What is expected output from this sample.
I'll take it back to square 1, because I doubt I was clear in the ask. The 2 columns that matter are the Parent Work Item ID and Work Item ID.
I need to create a Heirarchy so the first step would be to create a new column:
Heirarchy Path = PATH('Work Items - Today'[Work Item Id],'Work Items - Today'[Parent Work Item Id])
That gives me this error:
So to create the list of all the work items that will throw this error, I ran the command:
new ParentID = LOOKUPVALUE('Work Items - Today'[Work Item Id],'Work Items - Today'[Work Item Id],'Work Items - Today'[Parent Work Item Id])So what I want to do is to remove the blank values from the query, since those blanks are the ones that will throw the error in the path.
Does that make sense?
- parry2k
I'm unable to produce the erorr whcih you are getting using PATH function, I just used used your data set and all worked fine. Not sure why you are getting on that specific parent work item, if there is no child records (work item id), it will still work.