Seconds to dd hh mm ss

[Sujit_Thakur]

Dear all , 

I have created a measure which does proper calculation and returns seconds .for example 673929 seconds .

Now can I do something to get this measure return me in format of

day : hours

Please help

[ryan_mayu]

@Sujit_Thakur 

please try this

Measure 2 = 
VAR _cal=[Measure]/60/60/24
var day=int(_cal)
var hour=int((_cal-day)*24)
return day&":"&hour

[Greg_Deckler]

@Sujit_Thakur - See Chelsie Eiden's Duration - https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

Uses Custom format strings:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

If you want this as an actual measure/column:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

[amitchandak · Accepted solution]

@Sujit_Thakur , refer if this can help

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...