Forum Discussion
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 formula is
Right now my dataset has duplicate descriptions so when I do an average of these days it isn't accurate turnaround time since there are multiple of the same rows for each request
I have 29 unique requests and am hoping to calc out:
average turnaround time for only these 29. Any help would be much appreciated!
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
2 Replies
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