How to separating negative and positive values into two different columns

[Anonymous]

I have this creditors list and i would like to separate DR values and CR values into two different columns.

Regards,

CarolRamza 

[mattbrice]

Just add two calculated columns to data table:

Debit Column:

IF ( Table[Amount] >= 0, Table[Amount] )

Credit Column:

IF ( Table[Amount] < 0, Table[Amount] )

[Anonymous · Accepted solution]

@mattbrice 

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]))).

[v-chuncz-msft]

@Anonymous,

Reopen the file and try again.

Column =
IF ( 'Original Data'[Amount] >= 0, 'Original Data'[Amount] )

[Anonymous]

@v-chuncz-msft

Thanks i have tried that, but its still giving me errors. See screenshot below.

[mattbrice]

table with ‘Amount’ is ‘Original data’? You are trying to create calculated column?

[Anonymous]

@mattbrice 

Yes table with ‘Amount’ is ‘Original data’. Am actuctually trying to create two new cloumns; debit and credit. However the issue is 'how do i separate those values since they are in the same column?

[mattbrice]

Like I already posted.  Add two calculated columns.  I do it with accounting data all the time.  You must have syntax error or something as this is really basic.  

Post a link to file for someone to look at. 

[Anonymous]

@v-jiascu-msft kindly assist.

Regards,

CarolRamza