Forum Discussion
Solved
lookup same table for referenced field values
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.
Try the following DAX:
abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))
3 Replies
Try the following DAX:
abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))thank you very much!
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?
