title: How to find the average time per job id in power bi?
body: <p>I need to find the average time per job id.</p>
  <p>Below is the data</p>
  <p><a href="https://i.stack.imgur.com/NJHNA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NJHNA.png" alt="enter image description here" /></a></p>
  <p>I tried this dax query</p>
  <pre><code>AverageTime =
  AVERAGEX (
      VALUES ( Ratings[Date] ),
      CALCULATE ( AVERAGE ( Ratings[job_id] ) )
  )
  </code></pre>
  <p>Data type of Date is <strong>Time</strong></p>