topic Re: Convert Excel Formula to DAX in DAX Commands and Tips

Convert Excel Formula to DAX

Anonymous — Mon, 19 Aug 2024 22:41:20 GMT

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!!

Re: Convert Excel Formula to DAX

Brightsider — Mon, 19 Aug 2024 22:55:06 GMT

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.

Re: Convert Excel Formula to DAX

Anonymous — Mon, 19 Aug 2024 22:59:28 GMT

That worked thank you!