Network Days Calculation between both Error shown

[JawaharPrem6]

Hi,

Getting error while doing network days calculation, for this calculation i create a new table with date, week end Workday as given below.

and getting error while calculating 

Process_Time_New =

var _Start = Gobal_Master_Data_NA[Received_Date]

var _End = Gobal_Master_Data_NA[Completed_Date]

Return SUMX(

    CALCULATETABLE(

        Working_Dates,

        DATESBETWEEN(Working_Dates[Date],_Start,_End),

        Working_Dates[Workday]=1

    )

)

Thanks

Jawahar

[Anonymous]

Your solutions is great @bhanu_gautam 

Hi, @JawaharPrem6 

You can use the following DAX expression to calculate the number of network days excluding Saturday and Sunday:

NETWORKDAYS = NETWORKDAYS('Gobal_Master_Data_NA'[Received_Date],'Gobal_Master_Data_NA'[Completed_Date])

Here's the dataset I used:

Here are the results:

You can learn how to use this function from the link below:

NETWORKDAYS function (DAX) - DAX | Microsoft Learn

I've uploaded the PBIX file I used this time below. In addition, I found a case with the same issue:

Solved: Network Days Calculation for Power Bi - Microsoft Fabric Community

Solved: Network Days - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[bhanu_gautam]

@JawaharPrem6 , Try using below measure

Process_Time_New =
VAR _Start = Gobal_Master_Data_NA[Received_Date]
VAR _End = Gobal_Master_Data_NA[Completed_Date]
RETURN
COUNTROWS(
FILTER(
Working_Dates,
Working_Dates[Date] >= _Start &&
Working_Dates[Date] <= _End &&
Working_Dates[Workday] = 1
)
)

[JawaharPrem6]

Hi, Thanks for your time,

it working but its counting insted of calculating time..

calculated time like this