Forum Discussion
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 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.
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) )
3 Replies
- amitchandak
Super User
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) )
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?
