Forum Discussion
Solved
Need all my difference between dates to be positive
I'm doing a university assignment and part of the instructions is to show the time between an order and shipment date. Both dates came with hierarchies so I've made the column Delivery days = Data...
Use the full date columns and the DATEDIFF() function:
Delivery days = DATEDIFF ( Data[Order Date], Data[Delivery Date], DAY )If your assignment requires only positive values:
Delivery days = ABS( DATEDIFF ( Data[Order Date], Data[Delivery Date], DAY ) )
Hi Bcomm_student,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.