Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to Solution.
Hi,
if there is no relationship between two tables you should do it on this way:
then:
You're welcome. It seems that a conditional statement is not defined in your Filter() function and only the field name has been mentioned.
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
It seems that both side of the equal sign are columns of one table that not correct.
Hi,
if there is no relationship between two tables you should do it on this way:
then:
Hi @baghdadi62 thank you for your reply, this is what i have
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
29 | |
23 | |
22 | |
22 |