title: Matching rows between two columns to get an exact or partial match
body: <p>I’m having a problem writing a query in power bi for matching two rows partially or completely. In addition to that I’m trying to calculate the match percentage if found and put the results in a new column.</p>
  
  <p>The actual dataset contains a lot of rows and tables but for the sake of this example I’m using only 4 columns.</p>
  
  <p>The columns 'ID' and 'Text' are uniquely identified. 'KI ID' and 'KI Test' are also unique but they are not related to columns 'ID' and 'Text' only when a match occurs.</p>
  
  <p><strong>What I need to implement is the following:</strong></p>
  
  <p>I would like to match the input of each row in the 'Text' column with each row in the 'KI text' column. If there is a match, then I would like to know the 'KI ID’ and the Match percentage. Take a look at the data set for a better insight.</p>
  
  <p><strong>ps:</strong> Is this actually achievable with power query or is it just a fantasy because in my perspective I’m heading towards machine learning, I think?</p>
  
  <p>Data set
  <a href="https://drive.google.com/open?id=1JrsxPa6DICNi5N-tI5ESukh62W_uedaQ" rel="nofollow noreferrer">https://drive.google.com/open?id=1JrsxPa6DICNi5N-tI5ESukh62W_uedaQ</a></p>
  
  <p><a href="https://i.stack.imgur.com/WTXn4.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>The match calculation is based on the amount of words that occurs in both columns, 'Text' and 'KI Text'. for example, if one of the rows in the 'Text' column contains two sentences and these sentences partially matches with one of the 'KI Text' rows which has like 6 sentences in total. The match between the rows is partially so basically it should calculate it as 2/6 so it's like 33,3% match.</p>
  
  <p>In addition, the 'KI Text' column contains a lot of rows that could passably match with one of the ‘Text' column rows. Only if it's greater or equals to 80% then it should show the results otherwise it’s not interesting.</p>