Forum Discussion
Solved
DAX
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 r...
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) )
amitchandak
Super User
Super UserIncuseg , 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) )
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?
