Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

if DAX formula error

Hi Experts   Cannot see the error in my if formula. _Status = IF(ScheduleTask[status]="Complete", "Complete",IF(ScheduleTask[status]="Cancelled","Cancel",IF(and (ScheduleTask[status]="Active",Sc...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

highky recommend to use SWITCH() as mentioned mahoneypat 

 

_Status = 
SWITCH(TRUE(),
ScheduleTask[status]="Complete", "Complete",
ScheduleTask[status]="Cancelled","Cancel",
ScheduleTask[status]="Active" && ScheduleTask[primaryAuthor]="", "Unassigned",
ScheduleTask[status]="Active" && ScheduleTask[primaryAuthor]<>"", "Assigned",
ScheduleTask[status]="Active" && ScheduleTask[LifecycleStatusMatch]="", "inProgress",
ScheduleTask[LifecycleStatusMatch]
)