Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
MP_123
Microsoft Employee
Microsoft Employee

converting number to time

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!

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

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.

 

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

View solution in original post

1 REPLY 1
OwenAuger
Super User
Super User

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.

 

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.