Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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
Proud to be a Super User!
Yes. That is the result I am looking for in.
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
Proud to be a Super User!
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.
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |