cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kschimmo
Frequent 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:

 

IDLinked_Issues_IssuesLinked_Issues_Link_TypeLinked_Issues_Issue_KeyLinked_Issues_Direction
2827446440RelatesMDSUP-1090Inward
2827446407RelatesMDSUP-1051Outward
2827546440RelatesMDSUP-1090Outward
2827546441RelatesMDSUP-1091Inward

 

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 IDLinked Issues
MDSUP-1090

MDSUP-1051, MDSUP-1091

 

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User II
Super User II

@kschimmo is this what you want?

wdx223_Daniel_0-1606698587068.png

 

View solution in original post

6 REPLIES 6
wdx223_Daniel
Super User II
Super User II

@kschimmo is this what you want?

wdx223_Daniel_0-1606698587068.png

 

View solution in original post

Nathaniel_C
Super User I
Super User I

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

 





Did I answer your question? Mark my post as a solution!

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




kschimmo
Frequent Visitor

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.

 

 

kschimmo_0-1606605591365.png

 

Nathaniel_C
Super User I
Super User I

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors