Chelsie Eiden's Duration

Chelsie Eiden is my new favorite human being on the face of the planet. I don't know her major but, even if she is majoring in math, it still wouldn't change my mind on this one. That's how much I li...

ChelsieEidensDuration.pbix145 KB

Other

Time Intelligence

Totals

ARVINDlsllp

Frequent Visitor

2 years ago

Hello

Can anyone help me with the DAX , I have created a column in table but total is not appearing at the end i am using table visual .

Total =
VAR StartTime = ('All Measures'[Mea_New_Gen_Reg_Tim])
VAR EndTime = ('UN_ASYMAN_TRACK'[Released_Date_Time])
VAR Difference = EndTime - StartTime
VAR TotalHours = INT(Difference * 24)
VAR TotalMinutes = INT(MOD(Difference * 24 * 60, 60))
VAR TotalSeconds = INT(MOD(Difference * 24 * 60 * 60, 60))
RETURN
IF(Difference < 0, BLANK(), FORMAT(TotalHours, "00") & ":" & FORMAT(TotalMinutes, "00") & ":" & FORMAT(TotalSeconds, "00"))

PranamG

New Member

2 years ago

The total seems accurate. The date difference between the 2 dates seem to be 414 days and change hours. Did you want the total to appear as Days, Hours, Minutes and Seconds? If yes, please refer to below comment by nigeldavidmaxey on how to set this up to reflect days, hours, minutes and seconds.