Getting time average

[svelazquez]

Hi everyone,

I am trying to get an Average of one Column with the following formtat: (hh:nn:ss) 

When using the SUM calculation, it gives me the right number , however, when I change the calculation to AVERAGE, it changes the result format automatically.

My question here is, what can I do to get the AVERAGE of my column with the same format (hh:nn:ss)?

[danextian · Accepted solution]

Hi @svelazquez ,

You can create another measure that does the formatting. Example:

MyMeasure =
FORMAT ( [average measure], "hh:mm:ss" )

The above measure returns a text string.