Compare text in columns

[Bergh]

Hi!
I would like to be able to search on an article number. Can you then do so that you look in Description and compare in Table 2 Description and show the article numbers that contain similar words in description. Table 1 ICL and Hardware, Table 2 finds ICL and Hardware. Then I want the new partnumber 56789 ,98754 & 22654 to appear

[NaveenGandhi]

Hello @Bergh 

You can play around with fuzzy match in merge queries to bring the table 1 description to table 2 as below. Refer my fuzzy match settings from below SS.

Now you can close and apply, use the below two DAX.

To be created as column in table 2:

Concate Parts =
CALCULATE (
CONCATENATEX (
'Part number 2',
'Part number 2'[New Part Numbre],
", ",
'Part number 2'[Table 1 Description], ASC
),
ALLEXCEPT ( 'Part number 2', 'Part number 2'[Table 1 Description] )
)

To be created as column in table 1:

New Part Number =
LOOKUPVALUE (
'Part number 2'[Concate Parts],
'Part Number 2'[Table 1 Description], 'Part number 1'[Description]
)

Let me know if this helps.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

[pratyashasamal]

Hi @Bergh ,
Please refer to this link :-
https://www.spguides.com/power-bi-compares-two-columns-in-different-tables/
Hope it is helpful .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C