Keep the value as Negative for specific records

[alikwt]

I have a Table named "ICS_Transaction" in my SQL Database. 

There is a column named "Net_Amt_LC" that shows the net amount of the transaction. 

There is another column named "Voucher_Type" that shows a value 2021 for Credit Sales Transactions and 2023 for Credit Sales Returns. 

The values in Net_Amt_LC are all positives. And I want to bring Net_Amt_LC values as negatives for all those transactions that has Voucher_Type = 2023. 

Please help! 

[jthomson · Accepted solution]

In Power Query, make a column:

NALCneg = [Net_Amt_LC]*-1

Then make another column:

NewNALC = if [Voucher_Type] = 2021 then [Net_Amt_LC] else [NALCneg]