converting number to time

[MP_123]

hi, i have a calculated measure to calculate a number that means seconds. 

for example the measure = 150 (seconds)

i want the result will be 2:30  - 2 minutes and a half

how can i convert the measure?

thanks!

[OwenAuger · Accepted solution]

Hi @MP_123

One way would be to define a measure of type Time:

TimeMeasure =
TIME ( 0, 0, [SecondsMeasure] )

(assuming your original measure is called SecondsMeasure).

You can then apply an appropriate format to the measure.

You could also use the FORMAT function if you are happy to have a Text measure.