Forum Discussion
Subtract Time Entries
Hello and thank you for taking the time to review my request. I am trying figure out a way to subtract two time entries based on the following condition; If 'Event Id' has the same value AND con...
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
Carmichael
Advocate III
Advocate IIIAny chance you can could maybe use power query to reshape your data? It sounds like for this specific report you might be better off having the times in different columns?