Average of time

[key_master_95]

Hello!

I have tablee with time column in format - hh:mm. The column indicated as Spend time on site. Now, I need to define avarage of this column. 

When I created card and added  Spend time on site to value thus I received uncorrect decimal number.

How I can fix it?

Thank you in advance!

[pbix1]

Hi key_master_95

You could change the time into a number of minutes.

Column = value('Table'[Column1])*1440

Would give you the time spent in minutes. You could then perform an average on this. Would that work?

If you needed to have the average time in hours and minutes, you could then have another calculation to turn the average back into hours and minutes. That would be my suggestion.

Neil

[key_master_95]

I tried it too, but here was a problem with data format. 

Thank you for answer!

[Anonymous · Accepted solution]

Hi @key_master_95 ,

The DAX is basically summarizing the result. Please add the FORMAT function at the beginning and format it accordingly as you need.

Measure = FORMAT(AVERAGEA('Table'[Time]), "HH:MM:SS")

This should give you the output in the Time Format.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[key_master_95]

It works. Perfect!

Thank you a lot!

[Greg_Deckler]

@key_master_95 Check these out:

Duration to Seconds Converter - Microsoft Power BI Community

Chelsie Eiden's Duration - Microsoft Power BI Community

[key_master_95]

Thsnk you, but it doesn't work. I taped this formulas, but result is 0 (it's not true). I think, the first step is convert from HH:MM:SS to integer. But I don't know how to do it