https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/3306138#M157430 <P><BR />IF SUM([WFM_duration (copy)]) % 3600 &gt; 3570 AND SUM([WFM_duration (copy)]) % 3600 != 3600 THEN // rounding anything from 59:30 to next hour<BR />100<BR />ELSE<BR />IIF(SUM([WFM_duration (copy)]) % 60 &gt;= 30 AND SUM([WFM_duration (copy)]) % 60 != 60,1,0) // seconds<BR />+ IIF(INT(SUM([WFM_duration (copy)])/60) %60 == 60, 0, INT(SUM([WFM_duration (copy)])/60) %60) // minutes<BR />END<BR />+ INT(SUM([WFM_duration (copy)])/3600) * 100&nbsp; how to convert tableau calculation to power bi i need HH:MM:SS format and i want to aggregate the hours consumed</P> Wed, 28 Jun 2023 11:46:45 GMT Prathyusika 2023-06-28T11:46:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/3306138#M157430 <P><BR />IF SUM([WFM_duration (copy)]) % 3600 &gt; 3570 AND SUM([WFM_duration (copy)]) % 3600 != 3600 THEN // rounding anything from 59:30 to next hour<BR />100<BR />ELSE<BR />IIF(SUM([WFM_duration (copy)]) % 60 &gt;= 30 AND SUM([WFM_duration (copy)]) % 60 != 60,1,0) // seconds<BR />+ IIF(INT(SUM([WFM_duration (copy)])/60) %60 == 60, 0, INT(SUM([WFM_duration (copy)])/60) %60) // minutes<BR />END<BR />+ INT(SUM([WFM_duration (copy)])/3600) * 100&nbsp; how to convert tableau calculation to power bi i need HH:MM:SS format and i want to aggregate the hours consumed</P> Wed, 28 Jun 2023 11:46:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefined/m-p/3306138#M157430 Prathyusika 2023-06-28T11:46:45Z