Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |