Calculating Working hours

[Azeemuddin]

I have the following Data, I am trying to find a way to calculate Working hours between dates excluding Weekends.

Any help would be appreciated...

@amitchandak

[amitchandak · Accepted solution]

@Azeemuddin , if you only need days - use networkdays.

https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c

new column

networkdays([Created], [closed],1)

or

networkdays(datevalues([Created]),datevalues( [closed]),1)

for business hour: https://exceleratorbi.com.au/calculating-business-hours-using-dax/

For date from datetime use

datevalue([Created])

[Azeemuddin]

Thank you so much, Amit

for business hour: https://exceleratorbi.com.au/calculating-business-hours-using-dax/

The above solution solves my issue.