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.
The error I am receiving is RELATED has only one argument
Thanks for help.
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.
Code:
=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.
Last edited: