Forum Discussion
csv value filter
Hi All,
I have ID and Name column in two different tables
ID is comma separated value.
| Table 1 |
| ID |
| 1,2,3 |
| 2,4 |
| 5,2 |
| Table 2 | |
| ID | Name |
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 5 | E |
I want to get Name column as comma separated as ID. The output should be :
| Table 3 | |
| ID | Name |
| 1,2,3 | A,B,C |
| 2,4 | B,D |
| 5,2 | E,B |
TIA
Hi Anonymous ,
You could create a column using the following formula:
Name = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table2[Name] ), FILTER ( Table2, SEARCH ( Table2[ID], Table1[ID], 1, 0 ) > 0 ) ), [Name], "," )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
3 Replies
Anonymous , In table a create a new column ID 1
Split ID1 on , into rows : https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Then combine Table 1 and table 2 using ID and ID1 and use concatenatex on Name
Hi Anonymous ,
You could create a column using the following formula:
Name = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table2[Name] ), FILTER ( Table2, SEARCH ( Table2[ID], Table1[ID], 1, 0 ) > 0 ) ), [Name], "," )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
