Forum Discussion

JawaharPrem6's avatar
JawaharPrem6
Icon for Helper I rankHelper I
2 years ago

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    ...
General Comment
Need Help
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

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's avatar
    JawaharPrem6
    Icon for Helper I rankHelper I
    2 years ago

    Hi, Thanks for your time,

    it working but its counting insted of calculating time..

     

    calculated time like this