Forum Discussion
mbrierley
Advocate II
Advocate IIAverage time appears as text
We report on average working time and each month a report is generated from our finance team that is sent to me. This provides an average number of hours individuals have worked in a 17 week period. ...
HI mbrierley,
In fact, power bi not support to do aggregated on a date or time values.I'd like to suggest you write a measure formula to do some transform on your time values(e.g. total second or other numeric value) before aggregated on it. Then you can convert them back to time values after calculations.
Aggregating Duration Time Aggregating Duration Time
Regards,
Xiaoxin Sheng
mbrierleyAdvocate II
Advocate IISorry, but I'm not following you. I've looked at the link you posted, but that doesn't add anything to the data that I have as mine is already in that format (hh:mm - see photo). Are you saying that its impossible to order my data based on the highest values to the lowest?