Forum Discussion

JLCote828's avatar
JLCote828
Frequent Visitor
1 year ago
Solved

New Calculated Column

Hi All -   I'm struggling to create a calculated column using values from another.  It can't be that difficult but I don't know why it's not coming to me!!! Essentially, if the "Transaction Code D...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi JLCote828 ,
    Thank you for the prompt response vicky_ and ajaybabuinturi !

    I try with following query:

    NEW COLUMN =
    VAR ReversalCodes = {
        "PIN Redeem", "Redeem", "Cancel", "Reversal",
        "OSI Db Adjust", "OSI Redeem", "Deactivation",
        "PIN Cash Out", "Mass Devaluation", "Keyed Cash Out",
        "Keyed Redeem"
    }
    RETURN
    IF(
        'Table'[Transaction Code Description] IN ReversalCodes,
        'Table'[Amount] * -1,
        'Table'[Amount]
    )

    Refer the attached file.
    If this solution meets your requirements, please consider marking it as the accepted solution.

    Thank you for being a valued member in Microsoft Fabric Community Forum!
    Regards,
    Pallavi.
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi JLCote828 ,
Thank you for the prompt response vicky_ and ajaybabuinturi !

I try with following query:

NEW COLUMN =
VAR ReversalCodes = {
    "PIN Redeem", "Redeem", "Cancel", "Reversal",
    "OSI Db Adjust", "OSI Redeem", "Deactivation",
    "PIN Cash Out", "Mass Devaluation", "Keyed Cash Out",
    "Keyed Redeem"
}
RETURN
IF(
    'Table'[Transaction Code Description] IN ReversalCodes,
    'Table'[Amount] * -1,
    'Table'[Amount]
)

Refer the attached file.
If this solution meets your requirements, please consider marking it as the accepted solution.

Thank you for being a valued member in Microsoft Fabric Community Forum!
Regards,
Pallavi.
  • JLCote828's avatar
    JLCote828
    Frequent Visitor
    1 year ago

    Thank you, Anonymous , ajaybabuinturi , and vicky_ , I SO much appreciate the assist!  I'll give these a try and keep you posted!

  • JLCote828's avatar
    JLCote828
    Frequent Visitor
    1 year ago

    I figured I'd start with the first suggestion and work my way down ... no need, this worked on the first try!  I can't thank you enough!  You're making me look smart!
    Thank you too ajaybabuinturi and vicky_  as well!!!