The syntax error

Question

Please tell me what i am doing wrong. Thank you.

SchKPI =

VAR DaysUntil = DATEDIFF(today(), msdyn_projecttask[Finish], DAY)

VAR ScheduleStatus = SWITCH(TRUE(),

(msdyn_projecttask[% Complete]<100 && DaysUntil < 0) || msdyn_projecttask[Finish] > msdyn_projecttask[Baseline Finish], "Off Schedule",

msdyn_projecttask[% Complete]<100 && DaysUntil < 45, "On Watch",

msdyn_projecttask[Finish] <= msdyn_projecttask[Baseline Finish], "On Schedule",

"Error")

lbendlin · Accepted Answer

You are missing the RETURN statement.

Forum Discussion