Help creating a table based on relationship within the table

[kschimmo]

I am working with Jira data with Issue Links. The table provided from Jira with the issue links has the following data:

ID	Linked_Issues_Issues	Linked_Issues_Link_Type	Linked_Issues_Issue_Key	Linked_Issues_Direction
28274	46440	Relates	MDSUP-1090	Inward
28274	46407	Relates	MDSUP-1051	Outward
28275	46440	Relates	MDSUP-1090	Outward
28275	46441	Relates	MDSUP-1091	Inward

I want to create a table that summarizes the associated links in a list for quick reference (and for query to see if particular projects are referenced). Want my results to look like this:

Issue ID	Linked Issues
MDSUP-1090	MDSUP-1051, MDSUP-1091

[wdx223_Daniel · Accepted solution]

@kschimmo is this what you want?

[Nathaniel_C]

Hi @kschimmo ,
Maybe I am over thinking this, would you expect your table to look like this?

Issue ID	Linked Issues
MDSUP-1051	MDSUP-1090
MDSUP-1090	MDSUP-1051, MDSUP-1091
MDSUP-1091	MDSUP-1090

Nathaniel

[kschimmo]

Yes. That is the result I am looking for in. 

[Nathaniel_C]

Hi @kschimmo ,
Still am over thinking it. Went down various paths. Calling for help from @jdbuchanan71 . John, figured that the logic is based on that each of these issues have an in / out. Tried various DAX, but the only thing that gets close is a NewTable with SUMMARIZECOLUMNS() and MIN()/MAX() to get both Issue IDS on the same row, so there is the link.
Here is my pbix, and took out all the relationships.

https://1drv.ms/u/s!AgCd7AyfqZtE2VrhBg2SgGlvrpB_?e=qTwOVv 
Good Luck,

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[kschimmo]

Thanks for the follow-up, @Nathaniel_C !

The data between ID and Linked_Issues_Issues ran together which confuses the situation.

Attaching an image of the file which separates it. In this you can see that the ID column shows the link to the other issue.

[Nathaniel_C]

Hi @kschimmo ,
What is the logic here? How would we know that MDSUP-1090 links to the other two? I can not tell from looking at your data

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel