Powerpivot - Create flag if the row value of one column exists anywhere in another column
<p>What I'm trying to accomplish doesn't seem too tricky, and should be doable I just can't seem to crack it.</p>

<p>All I need to do is create a calculated column that flags whether or not the row value in one column exists anywhere in another column within the same table.</p>

<pre><code>  id | Code 1        | Code 2         | Attempted results
--------------------------------------------------------------------------
   1 | 1095829       | 1093895        | Y               
   2 | 1093895       | 1838949        | N               
   3 | 1095289       | 1093910        | Y               
   4 | 1093910       | 1840193        | N    
</code></pre>

<p>So essentially, is Code 1 found anywhere in the code 2 column</p>