Forum Discussion
Solved
if statement with and logic
Kindly help how to convert the below excel formula to Power BI Power Query
IF((AND(B2>=0,B2<2)),"0-2 Weeks",IF((AND(B2>=2,BS<4)),"2-4 Weeks",IF((AND(B2>=4,B2<6)),"4-6 Weeks",IF((AND(B2>=6,B2<20)),"Others"))))
Note: B2 is the cell reference.
Thank you in advance!
Kurdapyo_pogi , Create a new column like
Switch( True(),
[B] < 2 ,"0-2 Weeks",
[B] < 4 ,"2-4 Weeks",
[B] < 6 ,"4-6 Weeks",
"Others")
1 Reply
- amitchandak
Super User
Kurdapyo_pogi , Create a new column like
Switch( True(),
[B] < 2 ,"0-2 Weeks",
[B] < 4 ,"2-4 Weeks",
[B] < 6 ,"4-6 Weeks",
"Others")