Forum Discussion
How to separating negative and positive values into two different columns
I have this creditors list and i would like to separate DR values and CR values into two different columns.
Regards,
CarolRamza
The formula you gave me is giving the error below.
The syntax for ''Original Data'' is incorrect. (DAX(IF('Original Data'[Amount] >=0, 'Original Data'[Amount]))).
8 Replies
Just add two calculated columns to data table:
Debit Column:
IF ( Table[Amount] >= 0, Table[Amount] )
Credit Column:
IF ( Table[Amount] < 0, Table[Amount] )
The formula you gave me is giving the error below.
The syntax for ''Original Data'' is incorrect. (DAX(IF('Original Data'[Amount] >=0, 'Original Data'[Amount]))).
Anonymous,
Reopen the file and try again.
Column = IF ( 'Original Data'[Amount] >= 0, 'Original Data'[Amount] )
