Forum Discussion
kschimmo
5 years agoFrequent Visitor
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_K...
- 5 years ago
kschimmo
5 years agoFrequent Visitor
Yes. That is the result I am looking for in.
Nathaniel_C
Community Champion
5 years agoHi 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