Forum Discussion
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 Description" = "XXXXX", then multiply by -1, otherwise, keep the original value.
| Transaction Code Description | Amount | NEW COLUMN |
| Issue | $ 25 | $ 25 |
| Merch Credit | $ 25 | $ 25 |
| PIN Redeem | $ 75 | $ (75) |
| Redeem | $ 100 | $ (100) |
| Cancel | $ 75 | $ (75) |
| Pre-auth Completion | $ 25 | $ 25 |
| Reversal | $ 50 | $ (50) |
| Keyed Issue | $ 100 | $ 100 |
| Keyed Merch Credit | $ 75 | $ 75 |
| OSI Db Adjust | $ 15 | $ (15) |
| PIN Issue | $ 25 | $ 25 |
| PIN Pre-auth Completion | $ 50 | $ 50 |
| Mass Valuation | $ 1,000 | $ 1,000 |
| OSI Redeem | $ 100 | $ (100) |
| OSI Cr Adjust | $ 75 | $ 75 |
| OSI Issue | $ 50 | $ 50 |
| Deactivation | $ 100 | $ (100) |
| PIN Cash Out | $ 75 | $ (75) |
| Issue Virtual | $ 200 | $ 200 |
| Mass Devaluation | $ 2,000 | $ (2,000) |
| Keyed Cash Out | $ 200 | $ (200) |
| OSI Merch Credit | $ 100 | $ 100 |
| Keyed Redeem | $ 75 | $ (75) |
| $ 4,615 | $ (1,115) |
Any help would be greatly appreciated.
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"}RETURNIF('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.
5 Replies
You could try something like the below:
New Column = IF(Table[Transaction Code] in {"Your", "Codes", "Here"}, Table[Amt] * -1, Table[Amt])Hi JLCote828 ,
You can try with
Column Name = IF('Table'[Transaction Code Description] = "XXXX", 'Table'[Amount] * -1, 'Table'[Amount])
If you want to give multiple description suse vicky_ code.
Thanks,
If the solution helps you please mark it as Accepted Solution✅ and give kudos 👍. So that others can easily found the solution.
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"}RETURNIF('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.Thank you, Anonymous , ajaybabuinturi , and vicky_ , I SO much appreciate the assist! I'll give these a try and keep you posted!
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!!!
