title: Use same column twice in a table - PowerBI
body: <p>I am currently working on a project on PowerBI. I have a database named <code>STATUS_PER_SCHEMA</code> which has a column named <code>RUN_TIME</code> which tells when the batch was run.  The database has values for RUN_TIME for each schema for the last 10 days. I want to use the same column twice in a single table. So basically I want the last and the first batch timing for each schema.</p>
  
  <p>It should look something like this.</p>
  
  <pre><code>SCHEMA  LAST_BATCH_RUN  EARLIEST_BATCH_RUN
  A   2018-05-21 12:00    2018-05-16 13:00
  B   2018-05-21 12:00    2018-05-16 13:00
  C   2018-05-21 12:00    2018-05-16 13:00
  D   2018-05-21 12:00    2018-05-16 13:00
  E   2018-05-21 12:00    2018-05-16 13:00
  F   2018-05-21 12:00    2018-05-16 13:00
  </code></pre>