Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Convert Excel Formula to DAX

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

  • 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.

2 Replies

  • 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      That worked thank you!