title: Get values from one table and put in other table based on other column DAX/Power Query M
body: <p>I need a help.
  I have one Table A with 2 columns - first is just some name and the other is a value. I have also Table B with 3 columns - fist with some names, second called valMin and third valMax. What I am trying to do is get the name (col1) from Table B and put into the new column in TableA based on the value in Table A, such that val from Table A is between the valMin and valMax in Table B. Example:</p>
  
  <pre><code>TableA            TableB                     Result   
  |NameA|valA|     |NameB|ValMin|ValMax|      |NameA|valA|NameB|
  ------------     ---------------------      ------------------  
  |Name1| 7  |     |BBBB |  1   |  5   |      |Name1| 7  |CCCC |  
  |NAme2| 3  |     |CCCC |  6   |  10  |      |NAme2| 3  |BBBB |
  </code></pre>
  
  <p>Is it possible to do using DAX or Power Query M? 
  I would appreciate your help!</p>