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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Convert number(minutes) to mm:ss

Hi!

 

I have a column which contains the duration of actions in minutes. I made a measure which is the sum of minutes divided by a certain value, so i got a number which is an average basically. And for example its 10,75. The question is: How can convert its measure to see 10:45(mm:ss) instead of 10,75(number).

 

Thanks for help!

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @Anonymous 

 

Try this for your new calculated column. Table1[CurrentColumn] is the column with the minutes in number format

 

 

NewColumn =
VAR _Mins = TRUNC(Table1[CurrentColumn])
VAR _Secs = (Table1[CurrentColumn] - _Mins) * 60
RETURN
   _Mins & ":" & FORMAT(_Secs;"00")

 

 

View solution in original post

2 REPLIES 2
AlB
Super User
Super User

Hi @Anonymous 

 

Try this for your new calculated column. Table1[CurrentColumn] is the column with the minutes in number format

 

 

NewColumn =
VAR _Mins = TRUNC(Table1[CurrentColumn])
VAR _Secs = (Table1[CurrentColumn] - _Mins) * 60
RETURN
   _Mins & ":" & FORMAT(_Secs;"00")

 

 

The above didn't work for me, but replacing it with comma instead of semicolon was the trick:

NewColumn =
VAR _Mins = TRUNC(Table1[CurrentColumn])
VAR _Secs = (Table1[CurrentColumn] - _Mins) * 60
RETURN
   _Mins & ":" & FORMAT(_Secs,"00")

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors