Forum Discussion
Post PartisanNeed help with the data and calculation
Post PartisanThis is not what my requirement is I have to show the average time when the ticket state was was open->active
similary average time when ticket was active->resolve.
Data-estDogResolver II
You never mentioned average in your original post. You can go the direct dax route by using AverageX.
'X' on a function calculates on a row by row basis before rolling it up into an aggregate. Precalculating the duration on a row level would still be more efficient. If you are dealing with a large number of rows on a highly used report you can do that later. Here is the DAX:
Avg Create to resolved = AVERAGEX(Sheet2, DATEDIFF(Sheet2[Create Date], Sheet2[resolved_date], MINUTE))
Please accept as solution to help others find quicker. Consider Kudos. 🙂- DiKi-I
I think I am not able to explain it properly.
I have to calculate the average time of a ticket when status changes from new to active based on starttime and endtime in the history table. Simlarly I have to calculate the average time of ticket when the status of ticket changes from active to resolve based on starttime and endtime. How I can do this dynamically using measure? I have history of tickets with its life cycle.- Data-estDog
So you are saying the Average Time of the day.... like 5:32 PM?
So 10 tickets had a status change at 5:30 and 10 other tickets had a status change at 5:34, so the average is 5:32?
If no, trying mocking up an example of the outcome you are looking for and posting it.