Change amount to a negative value based on data from a second table

[EmileeJade]

Hello. I am new to using Power BI and cannot seem to achieve what I need.

My data comes from a microsoft SQL database and there are two tables linked together. A dollar value exist in one table, and the transaction type of the dollar value (whether an invoice or a credit) exists in a second table.

Here it my table called dTransactions. The highlighted item should be a negative value

This is my second table called dSplitInvoices. The highlighted item is the matching invoice and shows a C for transaction type.

I know I need to create a new column that would change the macthing C items to a negative value. I assume this would be with an if statement, but am not sure how to make it work. I tried this based off reading other posts, but it doesn't work. It just creates the column with the same data.

Any help would be appreicated.

[tamerj1 · Accepted solution]

@EmileeJade 

You need first to merge the teo tables and retrieve the Transaction Type column from dSplitInvoices to dTransactions. Once done you can insert an if statement into "Replace Values" to change credit values to negative. 

[EmileeJade]

Thank you so much!!! This is what I needed