Forum Discussion
Anonymous
3 years agoNot applicable
How to create if statement with multiple categories
I am trying to create if statement with multiple categories in Power BI that is similiar to this formula I have in excel
=IFS(AND(E2>=8,E2<=12),"8-12 Days",AND(E2>=4,E2<=7),"4-7 Days",AND(E2>=1,E2<=3),"3 or Less Days",E2>=12,"Over 12 Days")
The cells E2 will be replaced by a measure I created called Days Since the Order was Placed. Here is what my data looks like now.
Any help or tips will be helpful. Thanks!
1 Reply
- amitchandakSuper User
Anonymous , You can use switch with true ()
Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56