If Statement with multiple conditions

[pbrainard]

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 [csAnnualIncomeEntry] <= 31050 and HouseholdSize = 2, 34950 and 3, etc.

[jdbuchanan71 · Accepted solution]

@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]

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

[Anonymous]

Hello @pbrainard , you can use switch instead of if, when your cases are more than two. 

here is the link with details :

SWITCH function (DAX) - DAX | Microsoft Docs

I hope it helps you.