Forum Discussion
Subtract Time Entries
A measure would be best practice (https://docs.microsoft.com/en-us/dax/average-function-dax)
However, you may look to just use the standard aggregation facility.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates
Create a bar chart.
x = Responder Type
y = response time
click on the values well and change the value from sum to average.
If I have answered your question please mark my post as the solutiuon. If any of my posts helped please 'like' them. Appreciate the Kudos.
Thanks
Let me know if you need the screenshots.
Yeah, could you provide screen shots. I'm sorry, I feel bad. I'm having trouble finding how to merge the Event Id and Responder Id column.
Ok will try again now. But here is how to merge columns.
https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8dNote - I used an online image scrape of one the images you posted to get the data. Not all came through accurate so I removed those columns.
1. the merged column (please see article on how to accomplish above)
2. pivot column (https://support.microsoft.com/en-us/office/pivot-columns-abc9c8da-3be9-44c4-886e-0be331ab387a)
3. subtract to get time difference
4. assuming you know how to load5. that might be another post to create the measure.
hope that helps
That worked!!! That's awesome...I can't thank you enough.
One more question if you don't mind...how can I calculate the average of the response time? I tried to create a quick measure but my values look odd.