Forum Discussion

GMadd's avatar
GMadd
Icon for Helper I rankHelper I
2 years ago

DAX OTIF Formula to Included Scheduled Pickup

I have the formula below to help calculate my OTIF but I forgot to include any order (delivery) that has a pick up appointment. Some of our customers will schedule pick up appointment that is after t...
saurabhtd's avatar
saurabhtd
Icon for Resolver II rankResolver II
2 years ago

GMadd  updated version of your formula
Category =
SWITCH(
TRUE(),
OTIF[Credit]= "VERKBELEG", "Credit",
OTIF[Full]= "Short", "Late",
OTIF[Delivery Created Dat] > OTIF[Act. Gds Mvmnt Date], "Held for Material",
OTIF[Act. Gds Mvmnt Date] > OTIF[Dlv Plnd PGI dt], "Late",
NOT(ISBLANK(OTIF[Pickup Appt Date])) && OTIF[Pickup Appt Date] > OTIF[Dlv Plnd PGI dt], "On-Time", 
"On-Time"
)

  • GMadd's avatar
    GMadd
    Icon for Helper I rankHelper I
    2 years ago

    thank you for your response but I guess I was not 100% on what I need. In my screen shot below I want the first delivery 88004495 to show On-Time since the Pick up Appt Date was after the Dlv Plnd PGI dt. There was no other reason for this to be late as it was not delayed due to waiting for product.  The next delivery is showing late as it should since it was shipped short. 

     

  • GMadd's avatar
    GMadd
    Icon for Helper I rankHelper I
    2 years ago

    Any chance you can look at me question above as the measure you supplied in not what I am looking for.