Dax -new column

[Timbuktu7]

Hello World,

I want to create a new column called Bank Draft Vs Card. If After Mode's (Reversal, Special Reversal, Problem) [3 CATEGORY] Prior mode is (Amex,Visa,Discover,MasterCard) then its card or else its Bank draft. 

[v-rzhou-msft · Accepted solution]

Hi @Timbuktu7 ,

You can try this code to create a calculated column.

NewColumn =
IF (
    AND (
        'TableName'[AfterMode] IN { "Reversal", "Special Reversal", "Problem" },
        'TableName'[PriorMode] IN { "Amex", "Visa", "Discover", "MasterCard" }
    ),
    "Card",
    "Bank Draft"
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

can you aslo provide the expected result? language alone sometimes is not tightly logical.