topic Re: Help creating a table based on relationship within the table in DAX Commands and Tips

Help creating a table based on relationship within the table

kschimmo — Sat, 28 Nov 2020 22:43:46 GMT

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

Re: Help creating a table based on relationship within the table

Nathaniel_C — Sat, 28 Nov 2020 23:13:42 GMT

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

Re: Help creating a table based on relationship within the table

kschimmo — Sat, 28 Nov 2020 23:22:52 GMT

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.

Re: Help creating a table based on relationship within the table

Nathaniel_C — Sun, 29 Nov 2020 01:02:07 GMT

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

Re: Help creating a table based on relationship within the table

kschimmo — Sun, 29 Nov 2020 02:14:52 GMT

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

Re: Help creating a table based on relationship within the table

Nathaniel_C — Sun, 29 Nov 2020 18:44:17 GMT

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

Re: Help creating a table based on relationship within the table

wdx223_Daniel — Mon, 30 Nov 2020 01:09:55 GMT

kschimmo is this what you want?