Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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!