Forum Discussion

abodqmm's avatar
abodqmm
Regular Visitor
2 years ago
Solved

Datediff negative results

guys i have a start time end an end  i calculate it right but there some wrong entries like the end time before the start and the results show in negative  in the datedif i want to make he negative...
Need Help
Tips and Tricks
  • danextian's avatar
    danextian
    2 years ago

    Hi abodqmm 

    You can modify your formula to below:

    =
VAR __DIFF =
    DATEDIFF ( 'TableName'[start_time], 'TableName'[end_time], MINUTE )
RETURN
    IF ( __DIFF < 0, BLANK (), __DIFF )

     

    My question  now is why would the difference return negative values? Shouldn't the end always be later than the start? You might need to include in your calculation the dates as well.

  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello abodqmm ,

     

    try the following

    Column = 
var diff = DATEDIFF('TableName'[start_time],'TableName'[end_time],MINUTE)
RETURN
IF(diff < 0,BLANK(),diff)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi abodqmm 

You can modify your formula to below:

=
VAR __DIFF =
    DATEDIFF ( 'TableName'[start_time], 'TableName'[end_time], MINUTE )
RETURN
    IF ( __DIFF < 0, BLANK (), __DIFF )

 

My question  now is why would the difference return negative values? Shouldn't the end always be later than the start? You might need to include in your calculation the dates as well.