https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Duration-Time-Tracker/m-p/3769407#M147217 <P><img /></P> <LI-CODE lang="markup">Duration = var d = [Current Time]-[Start Time] return INT(d*24) &amp; FORMAT(d,":nn:ss")</LI-CODE> Sun, 17 Mar 2024 14:28:48 GMT lbendlin 2024-03-17T14:28:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Duration-Time-Tracker/m-p/3769124#M147202 <P>I'm working on my first Power Bi dashboard.</P><P>I have very limited knowledge on PB &amp; DAX.</P><P>Need some help pulling duration in hh:mm:ss from a table to display in a tile.&nbsp;<BR />I've been able to successfully pull the Current Time and Start Time from the linked spreadsheet.</P><P>Duration will display as 1/1/1900 12:48:04 instead of hh:mm:ss.</P><P><img /><img /><BR />The Current Time refresh issue was solved by generating a new measure and using that instead of pulling the =NOW() from the table.</P><P>I've found links explaining that I may have to convert all dates and times into second and back to dates and hh:mm:ss inside PB.</P><P>Any help, advice and links are much appreciated.</P><P>&nbsp;</P><P>Below is an outline of what I'm trying to do.</P><P><BR /><img /></P><P>&nbsp;</P> Sun, 17 Mar 2024 02:59:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Duration-Time-Tracker/m-p/3769124#M147202 whatisbam 2024-03-17T02:59:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Duration-Time-Tracker/m-p/3769407#M147217 <P><img /></P> <LI-CODE lang="markup">Duration = var d = [Current Time]-[Start Time] return INT(d*24) &amp; FORMAT(d,":nn:ss")</LI-CODE> Sun, 17 Mar 2024 14:28:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Duration-Time-Tracker/m-p/3769407#M147217 lbendlin 2024-03-17T14:28:48Z