How to format a measure that is in seconds as hours minutes and seconds

Imagine you have a table column in a model that represents the duration of a period in seconds, and you plan to use it to create a measure. The resulting measure should be able to bring back SUM, Average, Max etc. and the count is in number of seconds. 

As it it very complicated to relate time in seconds for larger numbers, you might prefer to present the results in a more convenient time format like hours minutes and seconds. This can be achieved pretty easily.

1. Just go to the measure settings and access the Format Mask
2. Delete the existing formatting and instead type “hh:mm:ss” (notice this can be done from the tables or the columns view)
3. Apply

 

 

After processing you will receive Seconds formatted as below

 

 

P.S. This will also work directly in a discover if you change the format in the measure properties. Or via the format pane in a discover.

 

Let us know how you like these small tips below