Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

Days Between Summed Up

Hello,   I have a calculated column where I calcualte the Days between the Max Delivery Date per Purchase Order.   CALCULATE(     DATEDIFF(         MAX('Purchase Orders'[Delivery Date.Delivery...
amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

This kind of works as a measure except is not totaling correctly. When i dump in excel the correct sum is -14,073.

 

 

 

Also is there a way for it to work as a calc column?

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
3 years ago

amandabus21  Try with:
Max Days Between =
VAR MaxDeliveryDate = MAX('Purchase Orders'[Delivery Date.Delivery Date Level 01])
RETURN
IF('Purchase Orders'[Delivery Date.Delivery Date Level 01] = MaxDeliveryDate,
DATEDIFF(MaxDeliveryDate, TODAY(), DAY),
BLANK()
)

BBF