topic Re: Dax Messure Error in DAX Commands and Tips

Dax Messure Error

Nathanael04 — Tue, 10 Jan 2023 00:57:06 GMT

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 — Tue, 10 Jan 2023 01:19:52 GMT

is order_estimated_delivery_date a measure or column?

Nathanael04 — Tue, 10 Jan 2023 01:24:20 GMT

column

FreemanZ — Tue, 10 Jan 2023 05:41:21 GMT

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

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