Hello!! I need to calculate 'Number of working hours between 2 dates'

[Anonymous]

This is achieved in MS Excel using the formula "=24*NETWORKDAYS(B2,C2)-24*((1-MOD(C2,1))+(MOD(B2,1)))"

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create calculated column as below to get it:

Working Hours between dates = 
24
    * COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                CALENDAR ( 'Table'[Start_Date], 'Table'[End_Date] ),
                "Day of Week", WEEKDAY ( [Date], 2 )
            ),
            [Day of Week] < 6
        )
    )
    - 24
        * (
            ( 1 - MOD ( 'Table'[End_Date], 1 ) )
                + ( MOD ( 'Table'[Start_Date], 1 ) )
        )

In addition, you can refer the content in the following links to achieve it.

DAX Fridays! #47: NETWORKDAYS

equivalent function of Networkdays in DAX

Best Regards

[amitchandak]

@Anonymous , if you need business hours refer this

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

If you need business day * 8

refer

Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA