Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AndyJ001
Frequent Visitor

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?

 

1 ACCEPTED SOLUTION
baghdadi62
Resolver III
Resolver III

Hi,

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

 

tbl imagetbl image

 

then:

2.JPG

View solution in original post

7 REPLIES 7
baghdadi62
Resolver III
Resolver III

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 conditionWith condition

 

Without 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]

@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.

baghdadi62
Resolver III
Resolver III

Hi,

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

 

tbl imagetbl image

 

then:

2.JPG

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors