Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert minutes to HH:MM - Calculated column

I have a field in Power BI which gives me the minutes number.   Example :- 14    I need to convert it to the format HH:MM. Please help   Examples    -- 14 need to be changed as 00:14 -- 62 n...
Need Help
Show and Tell
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    HI Anonymous 

    you can create a column with below code:-

     

    In Hours and Minutes = 
var _Minues='Convert HHM'[Column1]
var _Hours=int( _Minues/60)
var _RemMinutes=MOD(_Minues, 60)
return
  _Hours&":"&IF(_RemMinutes< 10,"0"&_RemMinutes,_RemMinutes)

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
5 years ago

HI Anonymous 

you can create a column with below code:-

 

In Hours and Minutes = 
var _Minues='Convert HHM'[Column1]
var _Hours=int( _Minues/60)
var _RemMinutes=MOD(_Minues, 60)
return
  _Hours&":"&IF(_RemMinutes< 10,"0"&_RemMinutes,_RemMinutes)

 

Thanks,

Samarth

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi

    I have a field in Power BI which gives me the minutes number.

     

    Example :- 186

     

    I need to convert it to the format HH:MM. Please help

     

    The above dax does not work

     

     

  • lroush259's avatar
    lroush259
    New Member
    3 years ago

    This solution worked perfectly for me when I found it for my project. My only outstanding problem is blank values showing up with  :  and not zeros. Another option would be to exclude those with zero but I am not able to filter due to the colon. Any ideas? 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    Unsure what I have done incorrectly, it does not pick up the column name "Loading TAT(mins)"