title: How to return a value from a row based on another column in power BI?
body: <p>In BI, is there a way to write a function that looks at Name 2 and pulls the score from the second column for that individual? Any help would be greatly appreciated!</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Name</th>
  <th style="text-align: center;">Score</th>
  <th style="text-align: right;">Name 2</th>
  <th style="text-align: right;">Score 2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">Bob</td>
  <td style="text-align: center;">100</td>
  <td style="text-align: right;">Sue</td>
  <td style="text-align: right;"></td>
  </tr>
  <tr>
  <td style="text-align: left;">Sue</td>
  <td style="text-align: center;">80</td>
  <td style="text-align: right;">Nick</td>
  <td style="text-align: right;"></td>
  </tr>
  <tr>
  <td style="text-align: left;">Nick</td>
  <td style="text-align: center;">50</td>
  <td style="text-align: right;">Bob</td>
  <td style="text-align: right;"></td>
  </tr>
  </tbody>
  </table>
  </div>