title: How Can I Transform Time Series in Power BI Into Time Bins
body: <p>I have a table with the following data:</p>
  
  <pre><code>Time                 Value
  2016-01-01 00:01:02  'a'
  2016-01-02 10:00:01  'b'
  2016-01-02 23:45:00  'c'
  </code></pre>
  
  <p>But I'd like to be able to generate a new table with regular times and the corresponding values, e.g.:</p>
  
  <pre><code>Data for 2016-01-02 by hour:
  
  Time                 Value
  2016-02-02 00:00:00  'a'
  2016-02-02 01:00:00  'a'
  2016-02-02 02:00:00  'a'
  ...
  2016-02-02 10:00:00  'a'
  2016-02-02 11:00:00  'b'
  2016-02-02 12:00:00  'b'
  ...
  2016-02-02 22:00:00  'b'
  2016-02-02 23:00:00  'b'
  </code></pre>
  
  <p>Can anyone help with an approach?</p>