Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to create 2 new calculated columns like follows
incoming = if [Debit/Credit] = S then [amount in company code currency]
outgoing = if [Debit/Credit] = H then [amount in company code currenty]*-1
I have used the below formulas
Solved! Go to Solution.
hi, @Anonymous
For your case, I think it is because the calculate column value is aggregated in the visual.
Please set them don't summarize, or change [amount in company code currency] is SUM
Best Regards,
Lin
hi, @Anonymous
For your case, I think it is because the calculate column value is aggregated in the visual.
Please set them don't summarize, or change [amount in company code currency] is SUM
Best Regards,
Lin
@Anonymous Hi,
Are credit and debit is same as incoming and outgoing? If it is same then it should be working fine. It worked for me.
another question is Are credit and debit Calculated column or Measures?
I don't know how I am getting the wrong values, but when I used the same data in a fresh pbix file the values are coming correct but in my existing if I implement the same logic wrong values are coming.
can anyone help me how to write the below query in M language
Outgoing = IF ( SAP_BSEG[Debit / Credit]="H", SAP_BSEG[Amount in company code currency]*-1,BLANK() )
@Anonymous
Use Table2 for Power Query solutions
https://1drv.ms/u/s!Ah0UhoGdkH5biiJPFN0W1s6GvEox?e=z1LTbx
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
I don't how you are getting incorrect results. I used same method howver I am getting correct results.
https://1drv.ms/u/s!Ah0UhoGdkH5biiJPFN0W1s6GvEox?e=z1LTbx
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |