Forum Discussion
What Happens when you sum datediff?
Hi I am reviewing an old PowerBi report I am redoing and believe that the numbers produce are incorrect. However, before I call them incorrect I wanted to understand what happens if you sum dat...
Hi HankScorpio2 ,
Thanks to the solution MFelix provided, datediff() is always the difference between the first date and the second date, so it goes negative when the first date is earlier. But these calculations are correct. You can calculate their absolute values with ABS() to make sure it's positive.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.