title: Duration calculation in hh:mm:ss using Power BI
body: <p>I have the following DAX in Power BI to calculate duration. How can I include the seconds?</p>
  <pre><code>Total Duration = sumx('Sheet1'; hour('Sheet1'[Duration])) +
  TRUNC(sumx('Sheet1'; MINUTE('Sheet1'[Duration]))/60) &amp; &quot;:&quot; &amp;
  mod(sumx('Sheet1'; MINUTE('Sheet1'[Duration])); 60)&amp; &quot;:00&quot;
  </code></pre>