How to convert an average of column in minutes into day, hr, min format

[sacheu]

Hi,

In my data source, I have a column 'Duration' which in an integer (in minutes).

And in my report, I have a  visual which display the average of that 'Duration'.

Right now, it is showing "3.76K" (in minute). How can I format that into # of Days, # of Hr, # of min?

Thank you.

[v-xulin-mstf]

Hi @sacheu,

You can try this:

Format =
var dayNo=INT([Duration]/1440)
var hourNo=INT(MOD([Duration],1440)/60)
var secondNo=INT(([Duration]-INT([Duration]))*60)
Return
 

Best Regards,

Link 

[amitchandak · Accepted solution]

@sacheu , Assuming duration is a measure , Create a new measure like

Quotient([Duration],60) &":" & mod([Duration],60)

also refer Duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389