Forum Discussion

Lakka00's avatar
Lakka00
Frequent Visitor
2 years ago

Time totals

I have a table which records the number of times someone is late and the time. I need it to be a count of lates and then in the last column the total time for the rows counted.   Below is how it is...
Need Help
Lakka00's avatar
Lakka00
Frequent Visitor
2 years ago

Hi, thank you but the 2nd column is the count of lates, I need the 3rd column to be the total amount of time late, for example, the first person was late 3 times, column 2 should show 3 lates and the last column should show 00:07:32 (Total time late of those 3 occasions)

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

hi Lakka00 

Can you try this dax present in the post.
https://community.fabric.microsoft.com/t5/Desktop/Working-with-time-duration/m-p/3674090

 

Or try this Dax

 

SumTalkTime =

VAR TotalSeconds=SUMX('Table Name',HOUR('Table Name'[Column])*3600+MINUTE('Table Name'[Column])*60+SECOND('Table Name'[Column]))
VAR Days =TRUNC(TotalSeconds/3600/24)
VAR Hors = TRUNC((TotalSeconds-Days*3600*24)/3600)
VAR Mins =TRUNC(MOD(TotalSeconds,3600)/60)
VAR Secs = MOD(TotalSeconds,60)
return IF(DAYS=0,"",IF(DAYS>1,DAYS&"days ",Days&"day"))&IF(Hors<10,"0"&Hors,Hors)&":"&IF(Mins<10,"0"&Mins,Mins)&":"&IF(Secs<10,"0"&Secs,Secs)

 

I hope I answered your question!