title: PowerBI Working hours calculation without start end time
body: <p>I have this table with only start time of every task. What I want to do is to calculate for every user his starting time (doesn't matter what task) and end time (doesn't matter what task). Basically I want working hours for each day for each each user.</p>
  <p><img src="https://i.stack.imgur.com/ligBo.jpg" alt="Data Table" /></p>
  <p>I tried to do this:</p>
  <pre><code>    enter work = MINX(
      SUMMARIZE(events,events[Date Only].[Date],events[user_id],
          &quot;MINN&quot;,MIN(events[ConvertedTimeToInteger])
      ),
      [minn]
  )
  
      exit work = MAXX(
      SUMMARIZE(events,events[Date Only].[Date],events[user_id],
          &quot;MAXX&quot;,MAX(events[ConvertedTimeToInteger])
      ),
      [MAXX]
  )
  </code></pre>
  <p>It works for a daily calculation, but for a total calculation its not good as it takes min/max of the date period:
  <img src="https://i.stack.imgur.com/v8YqX.jpg" alt="Table Results" /></p>
  <p>Any help much appreciated</p>