Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Louis63
New Member

Multiple conditional statement in Switch function

Hello, 

I have created the following formula to segment a table of customers according to their number of orders. I would like to add a condition to this formula which would be: "To be a Gold customer, the person must have ordered more than 15 times and spent $10,000", "To be a Silver customer, the person must have ordered more than 5 times and spent $7,000" for example. Is it possible to have 2 conditions in the SWITCH formula?

 

Louis63_0-1670256398742.png

 

Thanks for your help!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Louis63 , add additional condition

 

example

Switch(True() ,

[No] > 15 && [Spend] > 10000, "Gold" ,

// add others

)

 

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Louis63 , add additional condition

 

example

Switch(True() ,

[No] > 15 && [Spend] > 10000, "Gold" ,

// add others

)

 

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.