Calculate amount of days between 2 dates (excluding day off)

[Ponyglyph]

Hi everyone,

I'm facing an issue with Power BI, I would like to calculate the amount of days between 2 dates.

I can't use networkdays because I need a decimal number (I will convert it to Days/hours)
I need to calculate how long a case is open

So in my dim_date, I added the following calculated column:

Is_workday= IF(OR(DIM_Date[WeekDay] =6,DIM_Date[WeekDay] = 7),0,1)

And in my case table, I add the following column:

_Workdays =

    CALCULATE (

        SUM ( 'Calendar'[Is_workday] ),

        ALL ( 'Calendar' ),

        DATESBETWEEN ( 'Calendar'[Date], case[createdDate], case[closingDate])

but my column return blank value all the time...

Any idea of what I could do to solve this issue?

Many thanks for your help

    )

[Ponyglyph]

Networkdays returns whole number, and I woul like to get the time in hour
For example, if it returns 1.25, it means 30h 

[amitchandak]

@Ponyglyph , You can use networkdays, you can also supply a holiday list to this function

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c