Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Turnaround Time

I'm looking to calculate average turnaround time in my dataset but need help in adding a criteria to only calculate based off a distinct column called (Request Description) My turnaround time form...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Anonymous , Try using below mentioned method

     

    AverageTurnaroundTime =
    VAR DistinctRequests = DISTINCT('Tracker'[Request Description])
    RETURN
    AVERAGEX(
    DistinctRequests,
    CALCULATE(
    DATEDIFF('Tracker'[Request Received On], 'Tracker'[Completed Date], DAY)
    )
    )

     

    Please accept as solution and give kudos if it helps

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

Anonymous , Try using below mentioned method

 

AverageTurnaroundTime =
VAR DistinctRequests = DISTINCT('Tracker'[Request Description])
RETURN
AVERAGEX(
DistinctRequests,
CALCULATE(
DATEDIFF('Tracker'[Request Received On], 'Tracker'[Completed Date], DAY)
)
)

 

Please accept as solution and give kudos if it helps

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you so much!