Forum Discussion

aherabit's avatar
aherabit
Icon for Helper I rankHelper I
2 years ago
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 ...
  • vicky_'s avatar
    vicky_
    2 years ago

    Try the following DAX:

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

     

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

Try the following DAX:

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

 

  • aherabit's avatar
    aherabit
    Icon for Helper I rankHelper I
    2 years ago

    thank you very much!

  • aherabit's avatar
    aherabit
    Icon for Helper I rankHelper I
    2 years ago

    Hi Vicky.

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

    defectepicepic descriptionrequirements
    s-2s-20description s-20s-101
    s-18s-15epic description s-15s-3, s-4
    s-205s-15epic description s-15s-101

     

    from the following data source:

    issue keytypedescriptionepic link
    s-2defectdefect description s-2s-20
    s-3requirementrequirement description s-3s-15
    s-4requirementrequirement description s-4s-15
    s-15epicepic description s-15 
    s-18defectdescription s-18s-15
    s-20epicdescription s-20 
    s-101requirementdescription s-101s-20
    s-205defectdescription s-201s-15

     

    Could you lend a hand?