Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Thanks for your help!
Solved! Go to Solution.
@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
@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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.