Convert Excel Formula to DAX

[CiaraCaryl]

Could someone please help me convert this excel formula to DAX syntax?

=IF([@ARDivisionNo]="08", "Avertx Billing",IF([@[Current Product Line']]]="SAAS","SAAS Billing",IF([@[Current Product Line']]]="SUBS","SAAS Billing",IF([@[Current Product Line']]]="PERP","Perpetual Billing",IF([@[Current Product Line']]]="BDSW","Bundled Software Billing","Hardware Billing")))))

Thanks!!

[Brightsider · Accepted solution]

Try this:

SWITCH(
    TRUE,
    [ARDivisonNo] = "08", "Avertx Billing",
    [Current Product Line] = "SAAS", "SAAS Billing",
    [Current Product Line] = "SUBS", "SAAS Billing",
    [Current Product Line] = "PERP", "Perpetual Billing",
    [Current Product Line] = "BDSW", "Bundled Software Billing",
    TRUE, "Hardware Billing"
)

The SWITCH function will evaluate each condition from top to bottom, stopping when it returns a result of TRUE and returning the matching result. You might have to modify the above to take into account the table names your columns come from.

[CiaraCaryl]

That worked thank you!