Forum Discussion
Counting working days between two dates
Hi, I'm using the following formula to calculate working dates between two dates. It works great if the PickedDate comes after Delivery date. However, the formula returns a 0 instead of the negative ...
Hi,
Try if the following codes work for you...
DeliveryDaysVariance = CALCULATE ( SUM ( RollingDate[IsWorkDay] ), DATESBETWEEN ( RollingDate[Date], MIN(Invoices[DeliveryDate], Invoices[PickedDate]),MAX(Invoices[DeliveryDate], Invoices[PickedDate]) ) ) + 0- I made your formula work by adding a conditional column in the query edit. This column has -1 when the PickDate is prior to the DeliveryDate and 1 when it's after. Thank you!
Hi,
Try if the following codes work for you...
DeliveryDaysVariance =
CALCULATE (
SUM ( RollingDate[IsWorkDay] ),
DATESBETWEEN ( RollingDate[Date], MIN(Invoices[DeliveryDate], Invoices[PickedDate]),MAX(Invoices[DeliveryDate], Invoices[PickedDate]) )
)
+ 0 I made your formula work by adding a conditional column in the query edit. This column has -1 when the PickDate is prior to the DeliveryDate and 1 when it's after. Thank you!