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']]...
"DAX "
DAX ALL PowerBI Excel
Excel formula to Dax
  • Brightsider's avatar
    Brightsider
    2 years ago

    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.

Brightsider's avatar
Brightsider
Resolver I
2 years ago

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
    2 years ago

    That worked thank you!