Forum Discussion
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?
Hi,
if there is no relationship between two tables you should do it on this way:
tbl image
then:
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]
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.
It seems that both side of the equal sign are columns of one table that not correct.