Forum Discussion
AI14
Helper III
Helper IIIcompare text to time
Hi i need to see if my Actual is less than my target but they are in different formats. both are measures however 1 has been formatted into HH:MM so its a text and the other is a normal short tim...
Hi AI14
try to use TIMEVALUE function to convert Duration to datetime data type as follows
Duration =
VAR _ref =
MAX ( a[REF] )
VAR _time1 =
MAXX ( FILTER ( ALL ( a ), a[REF] = _ref ), [ST] )
VAR _time2 =
MINX ( FILTER ( ALL ( a ), a[REF] = _ref ), [ST] )
RETURN
TIMEVALUE ( FORMAT ( _time2 - _time1, "hh:mm" ) )
FreemanZ
Super User
Super Userchange the target, returns 1
AI14Helper III
Helper IIIalso Tried this but says i cant convert value " of type txt to type date
- AI14
the actual:
Duration =VAR _ref = MAX(a[REF])VAR _time1 =MAXX( FILTER( ALL(a), a[REF] = _ref ), [ST])VAR _time2 =MINX( FILTER( ALL(a), a[REF] = _ref ), [ST])RETURNFORMAT(_time2 - _time1, "hh:mm")the Target: (i have this as a measure and a column, both not worked)Target = 'Task Rules'[Earliest Start]+'Task Rules'[Duration]+'Task Rules'[Endbefore]+'Task Rules'[Setup]+'Task Rules'[Cleanup]- tamerj1
Community Champion
Hi AI14
try to use TIMEVALUE function to convert Duration to datetime data type as follows
Duration =
VAR _ref =
MAX ( a[REF] )
VAR _time1 =
MAXX ( FILTER ( ALL ( a ), a[REF] = _ref ), [ST] )
VAR _time2 =
MINX ( FILTER ( ALL ( a ), a[REF] = _ref ), [ST] )
RETURN
TIMEVALUE ( FORMAT ( _time2 - _time1, "hh:mm" ) )