Hi everybody! I'm still learning how to use Power BI, I search for this everywhere but I didn't found an answer!Here is the thing, I need to calculate the difference between dates and time, but the thing is that I need to calculate just the working days and the workhours.Taking the first line as an example: (03/11/2016 13:57:22 - 03/01/201613:36:38) the column hours should be 63:38:38Considering that 03/05 and 06/05 are saturday and sunday, and considering that the work hours are from 08:00AM to 18:00PM. How can I solve that! Thank you!

dcs136 How about the result if we update the “FirstDaySecDiff” measure as below? FirstDaySecDiff = IF ( Table1[FirstDayEndTime] >= Table1[DateTimeFrom] && Table1[FirstDayEndTime] <= Table1[DateTimeTo], DATEDIFF ( Table1[DateTimeFrom], Table1[FirstDayEndTime], SECOND ), IF ( Table1[FirstDayEndTime] >= Table1[DateTimeFrom] && Table1[FirstDayEndTime] > Table1[DateTimeTo], DATEDIFF ( Table1[DateTimeFrom], Table1[DateTimeTo], SECOND ), 0 ) ) Best Regards,Herbert

Calculate Date and Time difference considering the weekends and workhours

Forum Discussion

43 Replies

Related content