Forum Discussion
pbrainard
Helper III
Helper IIIIf 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 [csAnnualIncomeEntry] <= 31050 and HouseholdSize = 2, 34950 and 3, etc.
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" )
3 Replies
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.
- jdbuchanan71
Super User
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" )
pbrainardThank you!!! Good to see the SWITCH in action. Been looking for this fix!!!!
