Parent-Child Attribute/Field AzureDevOps/VSTS

[Sopanda]

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.

[arsaveli]

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]

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

[v-cherch-msft]

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,

[v-cherch-msft]

Hi @Sopanda 

Please have a look at this article.I would suggest you post your question here to get more professional help.

Regards,