Forum Discussion

rcb0325's avatar
rcb0325
Helper I
5 years ago
Solved

Converting If/else statements from Excel

I have a table that I am trying to figure out the DAX input for. The formula in excel was:    =if([Invoice Account]="112541",.11,IF([Customer Rebate Group]="TDG",.07,IF(OR([Invoice Account]="139871...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi rcb0325 ,


    You could modify measure by the following formula: 

    Rebate Multiplier =
IF (
    MAX ( [BillToCustomerCustomerNumber] ) = "112541",
    .11,
    IF (
        MAX ( [BillToCustomerCustomerRebateGroup] ) = "TDG",
        .07,
        IF (
            MAX ( [BillToCustomerCustomerNumber] ) = "139871"
                || MAX ( [BillToCustomerCustomerNumber] ) = "131324",
            .08,
            .07)))

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

The calculated column formula should remain the same in DAX as well.  Just replace Invoice Account, Customer Rebate Group and Invoice Account with customer numbers.

Hope this helps.