Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
16 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
23 | |
11 | |
10 | |
10 | |
8 |