Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have this if statement:
Go to Solution.
Try it in a SWITCH statement like this.
'Case'[csAnnualIncomeEntry] <= 27200 && MIN ( 'Case'[csHouseholdSize] ) = 1, "True",
'Case'[csAnnualIncomeEntry] <= 31050 && MIN ( 'Case'[csHouseholdSize] ) = 2, "True",
'Case'[csAnnualIncomeEntry] <= 34950 && MIN ( 'Case'[csHouseholdSize] ) = 3, "True",
View solution in original post
Thank you!!! Good to see the SWITCH in action. Been looking for this fix!!!!
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.