Forum Discussion
Network Days Calculation between both Error shown
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
3 Replies
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
)
)Hi, Thanks for your time,
it working but its counting insted of calculating time..
calculated time like this
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.
