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

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