Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[evano oruvan]

i want to create a conditonal formatting with background color for first customer priority ( we use direct query )

1. if currentAge < 60 and annualincome > 100,000 – priority should be green
2.if currentAge between 60 and 70 and annualincome between 60,000 and 100,000 – priority should be orange
3.if currentAge between > 70 and annualincome < 60,000 – priority should be red

——————————
evano oruvan
——————————

[Pulendar vadde]

You can use Switch Conditions together as below. You can just the conditions as per your requirements. Uploaded the file as well. 

Flag =

SWITCH(

TRUE(),

Emp[Income] >= 100000 && Emp[Age] >=60, “Green”,

Emp[Income] >= 70000 && Emp[Age] >=55, “Yellow”,

Emp[Income] >= 50000 && Emp[Age] >=40, “Red”)

Regards,
Pulendar V

——————————
Pulendar vadde
IT consultant
——————————
——————————————-