Forum Discussion
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:
7 Replies
Hi,
if there is no relationship between two tables you should do it on this way:
tbl image
then:
Hi baghdadi62 thank you for your reply, this is what i have
Column = CONCATENATEX(FILTER(Issues,Issues[IssueLinks.LINKED_ISSUE_KEY]),Issues[Organizations_14102.Organizations],",")Its now telling me i cant convert the value to true or false, any ideas? both columns are in the same data set but it should be returning many Organizations against a linked key but it doesnt seem to be working, any ideas?thank you again for your help
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 conditionWithout condition
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.
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]
