Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Delivery Status?

Hello Everyone    I'm hoping to get some help on a DAX formula that is above my current skill level   The company I work for has a requirement that supplier delivers must be +/- 3 days form the "...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    You can try this calc column. I named table "Deliveries" so you can change bolded part to your tables name. You can also use switch statment but I went old school on this one.

    Status =
    var daysdiff = IF(Deliveries[Received Date] = BLANK(), BLANK(),
    INT(Deliveries[Received Date]-Deliveries[Promised Date]))
    return
    IF(AND(Deliveries[Received Date] = BLANK(), INT(Deliveries[Received Date]-Deliveries[Promised Date]) < 4), "Pending",
    IF(daysdiff>3,"Received Late", IF(daysdiff <3,"Received Early",IF(daysdiff IN {-1,-2,-3,1,2,3},"Recieved On Time",
    "Late Not Yet Received"))))

     

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

You can try this calc column. I named table "Deliveries" so you can change bolded part to your tables name. You can also use switch statment but I went old school on this one.

Status =
var daysdiff = IF(Deliveries[Received Date] = BLANK(), BLANK(),
INT(Deliveries[Received Date]-Deliveries[Promised Date]))
return
IF(AND(Deliveries[Received Date] = BLANK(), INT(Deliveries[Received Date]-Deliveries[Promised Date]) < 4), "Pending",
IF(daysdiff>3,"Received Late", IF(daysdiff <3,"Received Early",IF(daysdiff IN {-1,-2,-3,1,2,3},"Recieved On Time",
"Late Not Yet Received"))))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Whitewater100, worked great!!