Forum Discussion

kschimmo's avatar
kschimmo
Frequent Visitor
5 years ago
Solved

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...
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
    kschimmo
    Frequent Visitor
    5 years ago

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

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      5 years ago

      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