Forum Discussion
Calculating time between despatching two orders
Anonymous
As mentioned earlier, there are duplicate dispatch dates in your data. To address this, sorting by order number is essential. If you sort by order number after the delivery date, you should obtain the desired result. If using the order number is not preferable, kindly specify your preferred sorting criteria for the dates.
It seems you're anticipating the previous row to display as it appears on the screen, but it's crucial to note that DAX requires proper sorting.
Thank you for your answer!
I used the formula, and I am getting this, which still seems not correct, some values are okay, some are not. You can see the formula, is there something I did wrong?
Anonymous
As mentioned earlier, there are duplicate dispatch dates in your data. To address this, sorting by order number is essential. If you sort by order number after the delivery date, you should obtain the desired result. If using the order number is not preferable, kindly specify your preferred sorting criteria for the dates.
It seems you're anticipating the previous row to display as it appears on the screen, but it's crucial to note that DAX requires proper sorting.