Network Days Calculation for Power Bi

[jawaharprm]

Hi All,

I have to calculate only working days, excluding Saturday and Sunday. i have created a Calander with shift timings and worked on DAX, but the issues is below mentioned columns are Text format. will some one help on same.

Rec Date= "02/28/2023 9:53 PM"
Comp Date= "02/29/2023 9:53 PM"

ProcessTime =
var _Start = 'Gobal_Master_Data_EU (3)'[Received_Date]
var _End = 'Gobal_Master_Data_EU (3)'[Completed_Date]
Return SUMX(
    CALCULATETABLE(
        Calendar_Table,
        DATESBETWEEN(Calendar_Table[Date],_Start,_End),
        Calendar_Table[workday]=1
    ),
    MAX(MIN(Calendar_Table[TimeEnd],_End) - MAX(Calendar_Table[TimeStart],_Start),0)*24
)

Thanks
Jawahar