title: How to fetch column from another Dimension table without relationship
body: <p>I have 2 dimension tables with no relation between them.</p>
  <p>1 is Product Dimension table as</p>
  <pre><code>ProdCode | ValidStartDate | ValidEndDate
  
  XX | 2012-01-01| 2016-12-31
  XX | 2017-01-01| 2017-12-31
  XX | 2018-01-01| 2020-12-31
  </code></pre>
  <p>2nd is Time table</p>
  <pre><code>Year | IsCurrent
  
  2012 | 0
  2013 | 0
  2014 | 0
  2015 | 0
  2016 | 0
  2017 | 0
  2018 | 0
  2019 | 0
  2020 | 1
  </code></pre>
  <p>I need to create a calculated column in Product table to show IsCurrent column from Time Table wrt the year selected.</p>
  <p>I tried with CALCULATE but it expects one of the aggregate functions which i can not use because i want to show value in current row context.</p>
  <p>for example:</p>
  <pre><code>IsCurrent =
  CALCULATE(
      MAXA('Time'[IsCurrent]),
      FILTER(
          'Time',
          'Time'[Year] &gt;= YEAR(Product[ValidStartDate]) 
              &amp;&amp; 'Time'[Year] &lt;= YEAR(Product[ValidEndDate])
      ) 
  )
  </code></pre>
  <p>This always gives me Max value from the range satisfied for example in case of 1st record (2012- 2016) shows 2016 always but I want to show respective current row year from Time table.</p>
  <p>Please suggest.</p>
  <p>Thank you.</p>