Forum Discussion
Parent-Child Attribute/Field AzureDevOps/VSTS
Hello, I'm currently using the Azure DevOps/VSTS connector to pull data into PBI. I was wondering if there was a way we could pull an attribute/field from a child/related WIT into the parent WIT...
Hey thanks for replying!
So in my data I have the parent work ids for child WITs. Is there a way for me to capture data from the parent WIT and apply it to the child in a new column?
I tired the following formula but it returned nothing to me. Seems like the formula I wrote will return the false result which would be returning nothing.
Custom Column =
IF('Work Item Fields'[Work Item Type]="Child WIT", IFERROR(LOOKUPVALUE('Work Item Fields'[Team Name],'Work Item Fields'[Work ID],'Work Item Fields'[Parent Work Item Id]),"ERROR"),"")
Hi Sopanda
Sample data and expected output will be helpful to provide an accurate solution.Could you follow the How to Get Your Question Answered Quickly to post your simplified assumed data and expected output?
Regards,