topic Re: DAX OTIF Formula to Included Scheduled Pickup in DAX Commands and Tips

DAX OTIF Formula to Included Scheduled Pickup

GMadd — Thu, 11 Jan 2024 21:41:51 GMT

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 the planned ship date (Dlv Plnd PGI dt) and if that is the case I do not want the order flagged as late due to the scheduled pickup appointment being different that the planned ship date. I have a column on my table that includes a date if there is a pick up appointment and is blank if it does not have a pick up appointment. What do I need to add to my formula below to take orders with pick up appoinments into consideration? Basically if the delivery has the Act. Gds Mvmnt Date after the Dlv Plnd PGI dt but has a Pick up Appt Date after the Dlv Plnd PGI dt I want the Category to be "On-Time".

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",

"On-Time"

)

Re: DAX OTIF Formula to Included Scheduled Pickup

saurabhtd — Fri, 12 Jan 2024 06:09:05 GMT

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"
)

Re: DAX OTIF Formula to Included Scheduled Pickup

GMadd — Fri, 12 Jan 2024 16:56:26 GMT

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.

Re: DAX OTIF Formula to Included Scheduled Pickup

GMadd — Wed, 24 Jan 2024 21:54:30 GMT

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