Needing to use relate to inverse number

[jak82]

Hi,

In PowerPivot I am bringing all my transactions into one table (Transactions) but am needing to turn all transactions with certain codes into a positive number.

I have another table called (LINK CODES) with the codes listed next to heading ie Revenue.

I want to say in the calculated column if that code is on the same row as 'Revenue' then make a positive number.

=IF(RELATED([posting_code],'LINK CODES'[aCode] = "Revenue"),[journal_amount],[journal_amount]*-1)

The error I am receiving is RELATED has only one argument

Thanks for help.

 

[jak82]

Solved

=IF(RELATED('LINK CODES'[Heading])="Revenue","yay","nay")