Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
walnei
Helper III
Helper III

TIME WITH MORE THAN 24 HOURS

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

 

Sem título3.png

5 REPLIES 5
Anonymous
Not applicable

DAX Mode ( In this mode you can agregate for any dimension)

 

QtSegundos = SUM([Seconds])

 

Time=
VAR Horas = INT([QtSegundos]/3600)
VAR Minutos = INT(([QtSegundos] - (Horas * 3600))/60)
VAR Segundos = MOD([QtSegundos];60)
RETURN
Horas&":"&FORMAT(Minutos;"00")&":"&FORMAT(Segundos;"00")
Anonymous
Not applicable

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.

 

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.

 

 

 

image.pngimage.pngimage.pngimage.png

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

Anonymous
Not applicable

Hi

HOUR returns the integer, so that will work here.

 

Hour.PNG

 

Hour1.PNG

 

 

Hope this helps.

 

Thanks

Raj

 

@Anonymous

Thank 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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.