TIME WITH MORE THAN 24 HOURS

Question

Could you help me with a DAX formula for the sum of time that goes by 24h. According to the sample print, in my example, when I try to calculate the TOTAL TIME and TOTALTIME * COUNT columns, I have the return according to line 1 when the right one would be the result of line 2

anonymous · Answer

HiHOUR returns the integer, so that will work here.&nbsp;&nbsp;&nbsp;&nbsp;Hope this helps.&nbsp;ThanksRaj&nbsp;

anonymous · Answer

I'm assuming you're talking about "durations", or an amount of time, rather than a time of day. Try setting your data types to duration, and then you can simply add them together.&nbsp;When you load it in, you'll get decimal numbers representing days, or 24-hour increments. You can then make measures accordingly to display however you want.&nbsp;&nbsp;&nbsp;

walnei · Answer

AnonymousThank you for your help. But the whole hours were just an example, to illustrate the scenario. But I also have minutes and seconds, for example: 11:24:35

walnei · Answer

I'll try that, and let me know if it worked.

anonymous · Answer

DAX Mode ( In this mode you can agregate for any dimension)&nbsp;QtSegundos = SUM([Seconds])&nbsp;Time=
VAR Horas = INT([QtSegundos]/3600)
VAR Minutos = INT(([QtSegundos] - (Horas * 3600))/60)
VAR Segundos = MOD([QtSegundos];60)
RETURN
Horas&amp;":"&amp;FORMAT(Minutos;"00")&amp;":"&amp;FORMAT(Segundos;"00")

Forum Discussion

TIME WITH MORE THAN 24 HOURS

Related content

Hour Calculation

create total hours from date time

Time + 6 hours

Change Time Format form 12 Hour to 24 Hour

Total hours as time from date time xl ; [h]:mm:ss