Dax Messure Error

[Nathanael04]

Hi, made this DAX ne messure and it give me this error.

Dispatch Status =

    SWITCH(

        TRUE(),

        [order_estimated_delivery_date] - [order_delivered_carrier_date] >= 5, "On Time",

        [order_estimated_delivery_date] - [order_delivered_carrier_date] < 0, "Late Dispatch",

        "Disputable"

    )

and it give me this error.
"The value for 'order_estimated_delivery_date' cannot be determined. Either the column doesn't exist,"

anyone can me any insite for this. thank you

[Nathanael04]

column

[FreemanZ · Accepted solution]

hi @Nathanael04 

your code is good for adding a calculated column, not good for a measure. 

p.s. please consider @ someone, if you seek further suggestions. 

[FreemanZ]

hi @Nathanael04 

is order_estimated_delivery_date a measure or column?