Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dax -new column

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 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.