Forum Discussion
Help creating a table based on relationship within the table
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 |
6 Replies
- Nathaniel_C
Community Champion
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
NathanielYes. 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
- wdx223_Daniel
- 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 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.
