Convert number(minutes) to mm:ss

[Anonymous]

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!

[AlB · Accepted solution]

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")

[evodio]

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")