title: Power BI Relationship if in range
body: <p>I have a table like (Table A) (Actual size more than 100 million records)</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>90</td>
  <td>A</td>
  </tr>
  <tr>
  <td>110</td>
  <td>B</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>And another one (Table B)</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID_MIN</th>
  <th>ID_MAX</th>
  <th>CAT</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>80</td>
  <td>100</td>
  <td>Cat1</td>
  </tr>
  <tr>
  <td>102</td>
  <td>115</td>
  <td>Cat2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want create relationship between these tables in POWER BI for modelling. It must be like; IF (Table A) ID between ID_MIN and ID_MAX.</p>
  <p>I can do it in sql easily like ; ... on ID&gt;=ID_MIN and ID&lt;=ID_MAX</p>
  <p>But in power BI there is no option like that.</p>
  <p>And also I do not want to create column with join in my fact table because it is extremly large.</p>
  <p>You need to know that for real Table B has more columns which I want to see em in my data model.</p>
  <p>Any ideas?</p>