title: power query merge two tables based on the transaction date between two dates
body: <p>I'm trying to perform a join between two tables (1 - transaction table and 2 - employee ID and date range) using Power Query where the transaction date is between two dates. </p>
  
  <p>Transaction Table</p>
  
  <pre><code>+-------+-----------------+--------+
  | EmpID | TransactionDate | Amount |
  +-------+-----------------+--------+
  |   123 | 5/5/2019        |     30 |
  |   345 | 2/23/2019       |     40 |
  |   456 | 4/3/2018        |     50 |
  +-------+-----------------+--------+
  </code></pre>
  
  <p>Employee ID</p>
  
  <pre><code>+-------+-----------+-----------+
  | EmpID | StartDate |  EndDate  |
  +-------+-----------+-----------+
  |   123 | 5/1/2019  | 5/30/2019 |
  +-------+-----------+-----------+
  </code></pre>
  
  <p>Desired Output</p>
  
  <pre><code>+-------+-----------------+--------+
  | EmpID | TransactionDate | Amount |
  +-------+-----------------+--------+
  |   123 | 5/5/2019        |     30 |
  |   456 | 4/3/2018        |     50 |
  +-------+-----------------+--------+
  </code></pre>
  
  <p>If i were to do this in SQL, i would write the following code:</p>
  
  <pre><code>select *
  from transaction as A
  inner join empID_date as B
  on A.EmployeeID = B.EmployeeID
  and A.TransactionDate &gt;= B.StartDate
  and A.TransactionDate &lt;= B.EndDate
  </code></pre>
  
  <p>is it possible to do this in Excel Power Query? thanks. </p>