Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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:
tbl image
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.With condition
Without 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
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:
tbl image
then:
Hi @baghdadi62 thank you for your reply, this is what i have
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
11 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |