title: Power bi: Fill cell based on criteria
body: <p>Hi I have two tables with the following structure:</p>
  
  <pre><code>RN  RO
  A   X
  B   Y
  C   Z
  D   Y
  E   Z
  F   X
  G   Z
  H   Y
  I   Z
  J   Z
  K   Y
  L   Y
  </code></pre>
  
  <p>and -</p>
  
  <pre><code>RN  Eff Ct  RO
  A   1   2   X
  B   1   2   Y
  C   1   2   Z
  D   1   2   Y
  E   1   2   Z
  F   1   2   X
  G   1   2   Z
  H   1   22  Y
  I   1   2   Z
  J   1   2   Z
  K   1   22  Y
  L   1   2   Y
  </code></pre>
  
  <p>I want to fill RO in table2 based on table1 without establishing any relationship between them.</p>
  
  <p>I tried doing this by making relationship and using <code>RON = IF('Table2'[RN] = FIRSTNONBLANK(Table1[RN],1), FIRSTNONBLANK(Table1[RO],1),"1")</code></p>
  
  <p>I need to remove this relationship any how.
  Is their any way to do this without establishing any relationship?</p>