Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this creditors list and i would like to separate DR values and CR values into two different columns.
Regards,
CarolRamza
Solved! Go to Solution.
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]))).
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]))).
Reopen the file and try again.
Column = IF ( 'Original Data'[Amount] >= 0, 'Original Data'[Amount] )
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?
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |