Forum Discussion
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...
hi Pat
not sure that is going to work its a calculated column in a table, my faut forgot to mention that.
Switch(true() works in calculated columns too. Here is what it your expression would look like with that approach:
_Status = SWITCH(TRUE(),
ScheduleTask[status]="Complete", "Complete",
ScheduleTask[status]="Cancelled","Cancel",
AND(ScheduleTask[status]="Active",ScheduleTask[primaryAuthor]=""),"Unassigned",
AND(ScheduleTask[status]="Active",ScheduleTask[primaryAuthor]<>""),"Assigned",
AND(ScheduleTask[status]="Active",ScheduleTask[LifecycleStatusMatch]=""),"inProgress",
ScheduleTask[LifecycleStatusMatch])
Easier to read at least. Does that work?
Regards,
Pat