Forum Discussion
amandabus21
Helper V
Helper VDays 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...
amandabus21Helper V
Helper VThat one did not work. Additonally I need a column becuase I need to run IF statements around it.
- BeaBF
Super User
amandabus21
Max Days Between =
VAR CurrentOrder = 'Purchase Orders'[Purchase Order #.Purchase Order # Level 01]
VAR CurrentDeliveryDate = 'Purchase Orders'[Delivery Date.Delivery Date Level 01]
VAR MaxDeliveryDate = CALCULATE(MAX('Purchase Orders'[Delivery Date.Delivery Date Level 01]), ALLEXCEPT('Purchase Orders', 'Purchase Orders'[Purchase Order #.Purchase Order # Level 01]))
RETURN
IF(CurrentDeliveryDate = MaxDeliveryDate, DATEDIFF(MaxDeliveryDate, TODAY(), DAY), BLANK())
BBF- amandabus21
Still not working.
For example for PO 4500055313 its saying the Sum of Days Between is -108 from 7/26/2023. When it should be -12 Days.
