Forum Discussion

AndyJ001's avatar
AndyJ001
Frequent Visitor
3 years ago
Solved

Return multiple values from lookup

Does anyone know if there is a way to lookup a value in a table and return multiple values split by comma in another column?  
  • baghdadi62's avatar
    baghdadi62
    3 years ago

    Hi,

    if there is no relationship between two tables you should do it on this way:

     

    tbl image

     

    then:

baghdadi62's avatar
baghdadi62
Resolver III
3 years ago

You're welcome. It seems that a conditional statement is not defined in your Filter() function and only the field name has been mentioned.

With condition

 

Without condition

AndyJ001's avatar
AndyJ001
Frequent Visitor
3 years ago

Thank you again for your help, this is now what i have 
Column = CONCATENATEX(FILTER(Issues,Issues[IssueLinks.LINKED_ISSUE_KEY]=Issues[IssueLinks.LINKED_ISSUE_KEY] ,Issues[Organizations_14102.Organizations],",")

what i am trying to do is bring back multiple Organizations against the linked issue key so like using lookupvalue to bring back multiple values split by a comma in one column.

  • baghdadi62's avatar
    baghdadi62
    Resolver III
    3 years ago

    Second parameter of Filter() function is not correct, I see both side of the equal sign are the same.

    Issues[IssueLinks.LINKED_ISSUE_KEY]=Issues[IssueLinks.LINKED_ISSUE_KEY]

    • AndyJ001's avatar
      AndyJ001
      Frequent Visitor
      3 years ago

      baghdadi62  i now haver this 

      Column = CONCATENATEX(FILTER(Issues,Issues[ISSUE_ID] = Issues[IssueLinks.LINKED_ISSUE_ID]),Issues[Organizations_14102.Organizations])
      this now is bringing back only blanks, what im trying to achieve is against each linked issue id there will be multiple Organizations_14102.Organizations so i need a similar function to lookupvalue but to bring back multiple values in one column split by a comma so using something a bit like this 
      LOOKUPVALUE(Issues[Organizations_14102.Organizations],Issues[ISSUE_KEY],Issues[IssueLinks.LINKED_ISSUE_KEY]) but to bring back multiple results.
      • baghdadi62's avatar
        baghdadi62
        Resolver III
        3 years ago

        It seems that both side of the equal sign are columns of one table that not correct.