Forum Discussion

pbrainard's avatar
pbrainard
Icon for Helper III rankHelper III
4 years ago
Solved

If Statement with multiple conditions

I have this if statement: AMI30% = IF( 'Case'[csAnnualIncomeEntry] <= 27200 && MIN('Case'[csHouseholdSize]) = 1, "True", "False" )   I want to do this logic a few times incorporating [csAnn...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    pbrainard 

    Try it in a SWITCH statement like this.

    AMI30% =
SWITCH (
    TRUE (),
    'Case'[csAnnualIncomeEntry] <= 27200 && MIN ( 'Case'[csHouseholdSize] ) = 1, "True",
    'Case'[csAnnualIncomeEntry] <= 31050 && MIN ( 'Case'[csHouseholdSize] ) = 2, "True",
    'Case'[csAnnualIncomeEntry] <= 34950 && MIN ( 'Case'[csHouseholdSize] ) = 3, "True",
    "False"
)
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

pbrainard 

Try it in a SWITCH statement like this.

AMI30% =
SWITCH (
    TRUE (),
    'Case'[csAnnualIncomeEntry] <= 27200 && MIN ( 'Case'[csHouseholdSize] ) = 1, "True",
    'Case'[csAnnualIncomeEntry] <= 31050 && MIN ( 'Case'[csHouseholdSize] ) = 2, "True",
    'Case'[csAnnualIncomeEntry] <= 34950 && MIN ( 'Case'[csHouseholdSize] ) = 3, "True",
    "False"
)
pbrainard's avatar
pbrainard
Icon for Helper III rankHelper III
4 years ago

Thank you!!! Good to see the SWITCH in action. Been looking for this fix!!!!