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...
Did you consider writing this as a SWITCH(TRUE(),... expression instead of nested IF()s? Check out this post.
https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/
Not sure if you want to rewrite this one but it will make the next one easier.
Regards
Pat