Find similar texts from two separate tables

[Anonymous]

I have two tables 

Table 1 - Part ID | Description

Table 2 - Service Part ID | Description

I want to find all the service parts for a part ID in Table 1 based on decription similarity from both the tables. 

[v-cazheng-msft]

Hi, @Anonymous 

Is your problem solved? If not, you can refer Compare text columns in two different tables and document the differences. If it doesn't work, please provide some sample data removing sensitive which will help solve this problem.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.