How to Format a duration (in seconds) in DD:HH:MM using a DAX measure

[slepre]

Hi All,

I needed to display a large number of seconds (duration) in a comprehensive format.

The below measure is working great:

duration_hh = int(sum(events[duration_sec])/(60*60*24)) & " Days, " & mod(int(sum(events[duration_sec])/(60*60)),24) & " hours and " & mod(int(sum(events[duration_sec])/60),60) & " minutes"

and to display the below in a card:

ttx = format(sum([duration_sec]),"#,###") & " seconds = " & [duration_hh]

Enjoy,

./Steph

[slepre · Accepted solution]

Hi All,

As you should have read, I was just sharing this measure with the community.

Not asking for support.

Thanks anyway 🙂

./Steph

[v-luwang-msft]

Hi @slepre ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it. 

Best Regards
Lucien

[v-luwang-msft]

Hi @slepre ,

Out put is below,what else you want to get？

Best Regards

Lucien

[amitchandak]

@slepre , measure ttx seem fine. I checked #,### work as a format and I am able to display it on card

What is the current output and how it is different from the expected one.