The syntax error

[PC2022]

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 solution]

You are missing the RETURN statement.

[PC2022]

Thank you!