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? The attribute or field does not exist in the parent WIT so I'm guessing when we obtain the child/related attribute it'll be in a new column for the parent to be used.

 

For example, the child/related WIT has the color attribute that contains "Blue". The parent WIT does not have the color attribute assoicate to it. We take the child/related WIT attribute and create a new column that the parent WIT can use containing the color.

 

I know that creating the same field in the parent WIT would make things easier but that is not an option for me.

 

 

Need Help

4 Replies

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