Forum Discussion

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Days to Complete a process

Hello Community: I am trying to compare the hospitals on how many days does it take on average(Hospital Average) to get thru all four treatments.  I will insert link for file with explanation on pa...
  • vapid128's avatar
    vapid128
    4 years ago

     

     

    In Table add colnum

    days = 
if([Step_ID]=1,
    1,
    [Time Out]-LOOKUPVALUE('Table'[Time Out],'Table'[Step_ID],'Table'[Step_ID]-1,'Table'[Patient_ID],'Table'[Patient_ID])
)

     

    add measure

    aveDays = AVERAGEX(VALUES('Table'[Patient_ID]),CALCULATE(SUM('Table'[days])))
vapid128's avatar
vapid128
Icon for Solution Specialist rankSolution Specialist
4 years ago

 

 

In Table add colnum

days = 
if([Step_ID]=1,
    1,
    [Time Out]-LOOKUPVALUE('Table'[Time Out],'Table'[Step_ID],'Table'[Step_ID]-1,'Table'[Patient_ID],'Table'[Patient_ID])
)

 

add measure

aveDays = AVERAGEX(VALUES('Table'[Patient_ID]),CALCULATE(SUM('Table'[days])))
Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Thanks very much. Nice job!