Forum Discussion
Search and get Multiple partial match results for each row using DAX
Hi
I am trying to search all partial matches for each value of one table from another table. Can someone help me in te below.
Thank you.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column in the Search table.
Partial match IDs CC = CONCATENATEX ( FILTER ( Source, CONTAINSSTRING ( Source[Name], 'Search'[Name] ) ), Source[ID], "; " )Hi,
Thank you for your message.
I do not know how your data model looks like, or how the relationship is created, but I assume there is no relationship between two table.
Please check the below picture and the attahced pbix file.
Partial match IDs CC = CONCATENATEX ( FILTER ( Source, CONTAINSSTRING ( Source[Name], 'Search'[Name] ) && Source[MID] = 'Search'[MID] ), Source[ID], "; " )
6 Replies
- Jihwan_Kim
Super User
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column in the Search table.
Partial match IDs CC = CONCATENATEX ( FILTER ( Source, CONTAINSSTRING ( Source[Name], 'Search'[Name] ) ), Source[ID], "; " )Thank you for the help.
Hi I'm having a similar query but without the option for a seperate Search Table.
Instead, I want to search the Source[ID] column against each value in the same column, Source[ID].
Essentially I want to search the Source[ID] column for repeats and then paste the data from an adjacent column Source[Machine Number] for those matching rows in concatenated form.
Thank you for any help!
Original Table:
ID Run1 Run2 Run3 Machine Number YE1 4 43 67 711 HJ3 5 16 21 712 RT5 6 90 12 713 HJ3 3 45 45 714 BN5 56 52 78 715 YE1 79 89 90 716 HJ3 23 23 43 717 Table with New Column:
ID Run1 Run2 Run3 Machine Number New Column YE1 4 43 67 711 716 HJ3 5 16 21 712 714,717 RT5 6 90 12 713 None HJ3 3 45 45 714 712,717 YE1 79 89 90 716 711 HJ3 23 23 43 717 712,714
Hi Jihwan_Kim Is it possible to inlude an additional condition like below.
concatenation should happen only in case of their MIDs are matching. Thank you in advance.
- Jihwan_Kim
Hi,
Thank you for your message.
I do not know how your data model looks like, or how the relationship is created, but I assume there is no relationship between two table.
Please check the below picture and the attahced pbix file.
Partial match IDs CC = CONCATENATEX ( FILTER ( Source, CONTAINSSTRING ( Source[Name], 'Search'[Name] ) && Source[MID] = 'Search'[MID] ), Source[ID], "; " )great! Thanks alot for the support.
