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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
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.