Forum Discussion
Anonymous
2 years agoNot applicable
Duration management
Hi all, I have an issue that is too specific to find existing discussions about it: So I have calculated a duration measure to know the response time excluding weekends. I found the below piece of...
Anonymous
2 years agoNot applicable
Hi Anonymous , thank you for your question. You could consider that the DAX function DATEDIFF - DAX Guide includes SECONDS, MINUTES and HOURS.
Table =
ADDCOLUMNS(
SELECTCOLUMNS(
{ ( DATE( 2023, 3, 31) + TIME( 13, 3, 12) , NOW() ) },
"Start", [Value1],
"End", [Value2]
),
"Seconds Difference", DATEDIFF([Start], [End] , SECOND),
"Minutes Difference", DATEDIFF([Start], [End] , MINUTE),
"Mod Difference",
VAR _diff = DATEDIFF([Start], [End] , SECOND)
VAR _day = QUOTIENT( _diff , 60 * 60 * 24 )
VAR _Mday = MOD( _diff , 60 * 60 * 24 )
VAR _hour = QUOTIENT( _Mday , 60 * 60 )
VAR _Mhour = MOD( _Mday , 60 * 60 )
VAR _minute = QUOTIENT( _Mhour , 60 )
RETURN
_day & " days " & _hour & " hours " & _minute & " minutes"
)
You can use these to measure MIN duration then convert result to Days, Hours, Minutes using QUOTIENT and MOD functions.