DAX

[Incuseg]

I need help with this dax, when I substract two times and one of them is higher than the other one, it gives me a negative result. How can I resolve this problem?

Here is the Dax Im using rigth now but is not working correctly, I dont know if I have to use the If(). The problem is I dont how to use it in my current Dax.

[FreemanZ]

hi @Incuseg 

try to wrap with ABS, like
ABS( DATEDIFF(... ) )

[amitchandak · Accepted solution]

@Incuseg , In date diff, first use smaller value .

else we need to adjust for day end

if([End Time] < [Start Time], datediff([End Time]+1, [Start Time], second) ,datediff([End Time], [Start Time], second) )

[Incuseg]

Thank you very much for your help, but now I have another problem. When I added new information, it gives me the result of the seconds in negative when it should be positive. How can i solve this?