Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
lookup same table for referenced field values
11-28-2023
12:27 PM
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.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2023
02:23 PM
Try the following DAX:
abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2023
02:23 PM
Try the following DAX:
abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023
04:41 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2023
03:18 PM
thank you very much!

Helpful resources
Top Solution Authors (Last Month)
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |