Forum Discussion

Sopanda's avatar
Sopanda
Frequent Visitor
7 years ago

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...
Need Help
arsaveli's avatar
arsaveli
Helper I
7 years ago

This should be possible to do as Analytics parent/child work items relationship.

However, since there can be multiple children you will not get the result in a simple one-column structure - it will be a complex object. It may be possible to just take first non-empty one, but either way you need to decide what to do if there are multiple children.

  • Sopanda's avatar
    Sopanda
    Frequent Visitor
    7 years ago

    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"),"")