Forum Discussion
Time difference between date time values in same column based on a value in a different column
Hi Anonymous ,
Here is the pbix PBIX
I put both columns in so that you have your choice, the second column only shows in the last row of the user. The difference between the measure and the column at the high level, is that with a measure, the engine does not have row context, whereas in the table it does. (It knows which row it is operating on.) Therefore it was just a matter of dropping MAX().
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Hi Anonymous
Or with zeros.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Elapse Secs Calc =
VAR _curTime =
MAX ( TimeElapse[Date Time Start] )
VAR _pasttime =
CALCULATE (
MAX ( TimeElapse[Date Time Start] ),
TimeElapse[Date Time Start] < _curTime,
ALLEXCEPT ( TimeElapse, TimeElapse[User], TimeElapse[Function] )
)
VAR _dif =
IF(ISBLANK(_pasttime), 0 ,DATEDIFF ( _pasttime, _curTime, SECOND ))
RETURN
_dif
Hi Anonymous ,
Here is the solution with only the final value showing for each User and Function.
Only latest value =
VAR _calc = [Cummulative]
VAR _maxDate =
CALCULATE (
MAX ( TimeElapse[Date Time Start] ),
ALLEXCEPT ( TimeElapse, TimeElapse[User], TimeElapse[Function] )
)
RETURN
IF ( MAX ( TimeElapse[Date Time Start] ) = _maxDate, [Cummulative], 0 )
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel