Forum Discussion
Values time duration not coming correctly
i, I have an excel file with time duration date per sales person, but when I import the excelfile to power BI and change the time duration to data type time, the values for time duration between ...
I have added a link to the excel file im using (http://www.filedropper.com/januaritidrapport). Im trying to summarize the the column "Overksam tid" by using the forrmula below, but as mentioned in previous mail it's not coming correct in Power BI.
Sum Overksam tid = VAR TotalSeconds = SUMX ( 'Tiddata'; HOUR ( 'Tiddata'[Overksam tid] )
* 3600 + MINUTE ( 'Tiddata'[Overksam tid] ) * 60 + SECOND
( 'Tiddata'[Overksam tid] ) ) VAR Hors = TRUNC
( TotalSeconds / 3600 ) VAR Mins = TRUNC
( MOD ( TotalSeconds; 3600 ) / 60 )
VAR Secs = MOD ( TotalSeconds; 60 )
RETURN IF ( Hors < 10; "0" & Hors; Hors )
& ":" & IF ( Mins < 10; "0" & Mins; Mins ) & ":" & IF ( Secs < 10; "0" & Secs; Secs )