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
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous, I think you should like

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

 

I doubt use of AND

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Amit

     

    its giving me errors with out the and....