Forum Discussion

Nathanael04's avatar
Nathanael04
Frequent Visitor
3 years ago
Solved

Dax Messure Error

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
 
 
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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. 

3 Replies