lookup same table for referenced field values

[aherabit]

Hi Folks,

I have a problem with looking the same table and capturing its values for referenced field values.

Here is my data table:

data table

issue id	abstract	related_issue_id
x-123	abstract-x123	y-543
x-234	abstract-x234
x-654	abstract-x654
y-543	abstract-y543	x-123
y-657	abstract-y657

I would like to capture the 'abstract' field values for all related_issues to produce the following visual/table:

(desired output)

issue id	abstract	related_issue_id	abstract_related_issue
x-123	abstract-x123	y-543	abstract-y543
x-234	abstract-x234
x-654	abstract-x654
y-543	abstract-y543	x-123	abstract-x123
y-657	abstract-y657

Thank you very much for any help.

[vicky_ · Accepted solution]

Try the following DAX:

abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))

[aherabit]

Hi Vicky.

If we expand on the solution by caluclating the following output:

defect	epic	epic description	requirements
s-2	s-20	description s-20	s-101
s-18	s-15	epic description s-15	s-3, s-4
s-205	s-15	epic description s-15	s-101

from the following data source:

issue key	type	description	epic link
s-2	defect	defect description s-2	s-20
s-3	requirement	requirement description s-3	s-15
s-4	requirement	requirement description s-4	s-15
s-15	epic	epic description s-15
s-18	defect	description s-18	s-15
s-20	epic	description s-20
s-101	requirement	description s-101	s-20
s-205	defect	description s-201	s-15

Could you lend a hand?

[aherabit]

thank you very much!