Forum Discussion

hsparg008's avatar
hsparg008
Frequent Visitor
4 years ago
Solved

Finding Working Hours Between Two Dates

I'm trying to find the number of working hours between two dates. I have a start and end date. Right now, I'm finding the number of working days between the dates and then multiplying it by the hours...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi hsparg008 ,

     

    A new DAX used to return the number of workdays between date range. It always returns whole number.

     

    NETWORKDAYS(<start_date>, <end_date>[, <weekend>, <holidays>])

     

    NETWORKDAYS function (DAX) - DAX | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi hsparg008 ,

 

A new DAX used to return the number of workdays between date range. It always returns whole number.

 

NETWORKDAYS(<start_date>, <end_date>[, <weekend>, <holidays>])

 

NETWORKDAYS function (DAX) - DAX | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.