Forum Discussion

walnei's avatar
walnei
Icon for Helper III rankHelper III
8 years ago

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 t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

HOUR returns the integer, so that will work here.

 

 

 

 

Hope this helps.

 

Thanks

Raj

 

walnei's avatar
walnei
Icon for Helper III rankHelper III
8 years ago

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