Forum Discussion
thetenz
3 years agoFrequent Visitor
Multiple if functions
Hello alll, I am trying to create a slicer that filters reports by 90 days, past due, due soon. How do I write the conditions below in Dax if due date is over 90 days ="past due" If due date...
lbendlin
3 years agoSuper User
SWITCH(TRUE(),
[Due Date]>90,"past due",
[Due Date]=90,"90 days",
[Due Date]>44,"due soon",
"not due soon")