topic Dax -new column in DAX Commands and Tips

Dax -new column

Anonymous — Mon, 12 Dec 2022 21:07:40 GMT

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.

Re: Dax -new column

FreemanZ — Mon, 12 Dec 2022 21:55:49 GMT

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

Re: Dax -new column

Anonymous — Tue, 13 Dec 2022 09:14:20 GMT

Hi Anonymous ,

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.